| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to select and count from a range of data
I have 3 data sheets:
Sheet1, sheet2, sheet3 From Sheet1 a value V1 is taken and looked up in Sheet2 another value corresponding to V1 ia taken say V2 (I tried doing this by Vlookup and am able to do find V1 and take V2) and V2 is checked in Sheet3 in data which is arranged horizontally and under this value I have a lot of values in the same column. I want to select this range of data and then count the number of cells for a particular value. How can i do it ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select range containing data | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| In data range select final value. | Excel Discussion (Misc queries) | |||
| Select data to appear on 2nd sheet by date range... | Excel Discussion (Misc queries) | |||
| Select updated data from a range of columns | Excel Worksheet Functions | |||
Threaded Mode
