| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
detemining values in a range
greetings! if i have a range say 40 columns by 10 rows with values in half
of the cells, is there a formula, or macro, or best method, where i can determine what values are in the range. note, there are many values which will show up multiple times in the range. i was hoping to use a pivot table but i'm not sure how to use one over a 40 by 10 range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| Max values from 2 ws and a range | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Last 2 values in range | Excel Discussion (Misc queries) | |||
Threaded Mode
