Hi Prashanth,
Your solution is perfect but the disadvantage is the file size is going to
increase as my data his huge. But good attempt i really appreciate
Regards,
Vinod
On Sat, Aug 22, 2009 at 9:02 AM, Prashant Bhawar
wrote:
>
>
> On Fri, Aug 21, 2009 at 1:09 PM, vinod rao wrote:
>
>> Hello
You're welcome.
Dave.
From: sandymau...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need Urgent help in finding formula.
Date: Sat, 22 Aug 2009 23:43:27 +0530
Hi Dave,
Thank you for this great information. These kind of things are not available in
ject: $$Excel-Macros$$ Re: Need Urgent help in finding formula.
Hi Sandeep,
The -- works on logical values, changing them from True to 1, or from False
to 0
Try putting 5 into Cell A1
Then put =(A1=5) into Cell A2
When you hit Enter, Cell A2 will read TRUE
If you change A1 to something
Hi
vinod
Use rank formula
e.g
=rank()
On Fri, Aug 21, 2009 at 2:16 PM, vinod rao wrote:
> Hi Team,
>
> Not in this way. :(
>
> First i do not want to sort.
> Second the ranking should be based on Glass and should not consider the
> city or district.
>
> Example
> Glass- Based on bigest value it
.
Hope this helps.
Regards - Dave.
From: sandymau...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need Urgent help in finding formula.
Date: Fri, 21 Aug 2009 17:53:44 +0530
Hi Dave
Please you tell me what is the purpose of -- in your sumproduct formula and
what
On Fri, Aug 21, 2009 at 1:09 PM, vinod rao wrote:
> Hello Team,
>
> I have attached file in which i need a formula in the column E, instead of
> the manual ranking in need a formula based on the item mentioned in the
> column C.
>
> Please make a note, ranking is based on the largest value to the
- Original Message -
From: Sandeep
To: excel-macros@googlegroups.com
Sent: Friday, August 21, 2009 5:53 PM
Subject: Re: $$Excel-Macros$$ Re: Need Urgent help in finding formula.
Hi Dave
Please you tell me what is the purpose of -- in your sumproduct formula and
what are the ways to
Hi Vinod,
Your data is not clear. Are you talking about the sorting to be done on
text enteries in column C, if so then is there any relation with the numbers
in column D, OR are you taking Glass/Tiles/Bricks as the order of sorting
like Big-Bigger-Biggest. Please explain? Thanks
--
DILIP KUM
Hi Dave,
You are a STAR!!!. I really appreciate your efforts. Thank you very much.
Best regards,
Vinod
On Fri, Aug 21, 2009 at 4:11 PM, Dave Bonallack
wrote:
> Hi Vinod,
> Have a look at the attached.
> I have had to use a helper column to extract the "Bricks, Tiles, Glass"
> info
> Then u
: Friday, August 21, 2009 4:11 PM
Subject: $$Excel-Macros$$ Re: Need Urgent help in finding formula.
Hi Vinod,
Have a look at the attached.
I have had to use a helper column to extract the "Bricks, Tiles, Glass" info
Then used that to rank the data.
Hope this helps.
Rega
Hi Vinod,
Have a look at the attached.
I have had to use a helper column to extract the "Bricks, Tiles, Glass" info
Then used that to rank the data.
Hope this helps.
Regards - Dave.
Date: Fri, 21 Aug 2009 13:09:40 +0530
Subject: $$Excel-Macros$$ Need Urgent help in finding formula.
From: vinod.ma
Hi Team,
Not in this way. :(
First i do not want to sort.
Second the ranking should be based on Glass and should not consider the city
or district.
Example
Glass- Based on bigest value it should rank (1,2,3)
Bricks- Based on bigest value it should rank (1,2,3)
Tiles - Based on bigest value it sh
12 matches
Mail list logo