Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a column which lists various dollar amounts (thousands of cells). I
want to search that column and locate cells which total a specific dollar amount. For example, a customer has fifty accounts with us and I know he paid $100.00 that were divided randomly over five of his accounts. I need to know which five accounts that $100.00 could have been spread across, so I need to find a way to search the column to find which cells total that $100.00. I have been unsuccessful in finding something suitable in the Help file. Thank you. -- C. Brown |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem in finding words into cells of a column | Excel Discussion (Misc queries) | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |