Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have sheet 1 with rooms (eg No 18) containing asbestos (4 items)
i have sheet 2 with rooms (eg No 18) containing NO asbestos (0 items) How do I combine both sheets onto sheet3 to show room 18 has 5 items (4 +ve and 1 -ve)? I want room 18 in column A and then 4 blank cells underneath with column B having the 5 items -- CHRISK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining sheets on one | Excel Worksheet Functions | |||
Links between sheets | Excel Discussion (Misc queries) | |||
Combining different sheets with automatic add in? | Excel Discussion (Misc queries) | |||
how do i find which sheets contain links? | Excel Worksheet Functions | |||
combining data from multiple sheets | Excel Worksheet Functions |