Great Mr. Paul. This is want I am looking for. Thanks again also thanks
mandeep.
Regards,
Ganesh N
On Wed, Jun 17, 2015 at 6:12 PM, Paul Schreiner
wrote:
> So you want to see ONLY the alphabetic characters?
> You want to filter OUT the numbers?
>
> If so, I think your terminology is reversed.
>
Thanks a lot.
*You are GREAT.*
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES, SAVE EARTH” *
*“All appears to change when we change!”*
On 17 June 2015 at 17:33, Paul Schreiner wrote:
> Since I don't know how many
Oh Fuck !!! how did you do that ? Amazed to see this result :) way to go
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June 17, 2015 at 6:13:03 PM UTC+5:30, Paul Schreiner wrote:
>
One possibility: combine all the individual tabs into a single tab to
create a data table of >all< the information, then create a pivot table to
quickly summarize data.
On Wednesday, June 17, 2015 at 1:50:33 AM UTC-4, Kumar Bhanushali wrote:
>
> *Dear Sir,*
>
> I had attached a file, in this f
So you want to see ONLY the alphabetic characters?You want to filter OUT the
numbers?
If so, I think your terminology is reversed.Think of Excel filters just like
any other filter you can think of:Coffee, tea, air/furnace
It's not what stays in the filter that has the most value, that's usually
Thanks Mr. Mandeep But no other option uh ?
Regards,
Ganesh N
On Wed, Jun 17, 2015 at 6:07 PM, Mandeep Baluja
wrote:
> Create a helper column right next to your data and use isText function
> with respect to left cell apply filter where it is true you can get the
> text value !!
>
> Regards,
>
Create a helper column right next to your data and use isText function with
respect to left cell apply filter where it is true you can get the text
value !!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=3125
Thanks Mr. Paul but how i filter none numeric value ?
Regards,
Ganesh N
On Wed, Jun 17, 2015 at 5:36 PM, Paul Schreiner
wrote:
> Simply turn on filters and select values > 0.
>
> (see attached)
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By
Simply turn on filters and select values > 0.
(see attached) Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John We
Since I don't know how many sheets are in your workbook, I chose an approach
that works quickly with a large number of sheets.
In the following macro, I defined a Dictionary Object and stored the names of
the sheets currently selected.
Then, I find the first sheet that is NOT in the list and sele
Many ways to do it ,
1) apply filter use criteria greator than 0
2) formula given to you below attachment
3) VBA
4) Sort it
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June 17
Dear Team,
Please help me to know how to filter only number in the list.
Please find the attachment.
Thanks & Regards,
GN
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/di
-- is used to convert it to numeric value it can give the result of true to
1 and false to 0. you were not getting the result just because the numbers
are stored as text which you are getting from the formula.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420
Dear Ashish,
Thanks for reply.
Problem solved but I want to know ,what differece (-- ) this makes.
Can you explain it please
Regards
Shrinivas
On Sat, Jun 13, 2015 at 5:33 PM, Ashish Bhalara
wrote:
> Make a little changes in your formula as mention below, then lookup on
> that value.
> =--MID(
14 matches
Mail list logo
