Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't consolidate non-data (ie text) cells from worksheets
I have got a number of worksheets containing lists of names/ Email addresses
ie. non-data (ie text) values . I want to consolidate these non-data (ie text) values from cells in different worksheets - but am failing. I have formatted the separate worksheets into lists, and then used the 'consolidate' function, but of course this requires a 'summary function' setting ('SUM', 'COUNT') - I can't see how to do this when it is a non-numerical value. Any help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Consolidate data from several worksheets via pivottable | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |