Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When I sort a list of product numbers appearing on invoices I identify a certain product number by highlighting the cell in yellow. My task if to find all invoices where the identified product number appears and all product numbers appearing on those invoices. Currently I sort the list by invoice number and manually identify the invoices that contain highlighted product numbers. Do the highlighted cells have a special value that would allow me to identify all product numbers appearing only on the invoices that have a highlighted cell?
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
View only Highlighted Cells | Excel Discussion (Misc queries) | |||
How can I protect only the highlighted cells in Excel? | Excel Discussion (Misc queries) | |||
Can I sum only highlighted cells in a worksheet? | Excel Worksheet Functions | |||
left click on a cell and more cells are highlighted | Excel Worksheet Functions |