| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Range Matrix
Hi all,
I am looking to display the following data into a matrix. Does anyone know how I can achieve this by formula or an Excel function. DATA A....50 B....150 C....60 D....200 MATRIX (count of data) .........0......100......200 0.......X.........2........4 100....X.........0........2 200....X.........X........1 Cheers in advance GarToms |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
Threaded Mode
