| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need the correct formula
The concat idea worked. Thank you very much!
-- Rob K "loudfish" wrote: On 9 May, 23:30, Rob K wrote: But I can't seem to further restrict the count to just 'data' and 'medium'. I've tried the If-And function without sucess. Thanks in advance -- Rob K Col A.........ColB Category....Priority Add ColC =A1&B1 This will concatenate the two values together. Copy this formula down. Now you can COUNTIF... using 'datamedium' HTH Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please Correct the formula | Excel Discussion (Misc queries) | |||
| what is the correct formula to add a column with =sum | New Users to Excel | |||
| How do I correct this formula? | Excel Worksheet Functions | |||
| What's the correct formula? | Excel Discussion (Misc queries) | |||
| How I need correct formula, that no t rounding? | Excel Worksheet Functions | |||
Hybrid Mode
