| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help me to sort out data by text
Hi all,
This is Charlie again to bother you. I remember last time you gave me solution for my excel query. I hope you will help me to solve this as well. Name hit1 hit2 hit3 a x e a c y d b b t u h a b t e c t s w a f t j b e i r Which advance function of excel can be used to find what 'a' is having (sum of text) in each column(hit1,hit2,hit3,hit4) data like "=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7=1))" to get product of numbers? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help me to sort out data by text
Do you mean
=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7="t")) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Charlie" wrote in message ... Hi all, This is Charlie again to bother you. I remember last time you gave me solution for my excel query. I hope you will help me to solve this as well. Name hit1 hit2 hit3 a x e a c y d b b t u h a b t e c t s w a f t j b e i r Which advance function of excel can be used to find what 'a' is having (sum of text) in each column(hit1,hit2,hit3,hit4) data like "=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7=1))" to get product of numbers? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help me to sort out data by text
Yes bob,You understood correct way.
I want to do that way only. thanks. "Bob Phillips" wrote: Do you mean =sumproduct(--(A$2:A$7="a"),--($B$2:$B$7="t")) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Charlie" wrote in message ... Hi all, This is Charlie again to bother you. I remember last time you gave me solution for my excel query. I hope you will help me to solve this as well. Name hit1 hit2 hit3 a x e a c y d b b t u h a b t e c t s w a f t j b e i r Which advance function of excel can be used to find what 'a' is having (sum of text) in each column(hit1,hit2,hit3,hit4) data like "=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7=1))" to get product of numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I sort text data by reference to text data in another column? | Excel Discussion (Misc queries) | |||
| Sort a column (specifically email data) by end of text, not beginn | Excel Worksheet Functions | |||
| import text and sort data into excel | Excel Worksheet Functions | |||
| import text and sort data into excel | Excel Worksheet Functions | |||
| How can I sort duplicate text data in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
