G
Guest
Often when accountants are reconciling accounts they need to find an error.
If I know my error is $6843 and it is a combinastion of 2 or more numbers
within my spreadsheet, then there should be function that finds the cell
combinations that make that number.
I picture it working like this: You highlight the cells you want to search
and then choose the function. The cell combinations are returned in a
seperate window and are limited to no more than 20 combinations. Once it
hits twenty one it returns a limit reached error.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
If I know my error is $6843 and it is a combinastion of 2 or more numbers
within my spreadsheet, then there should be function that finds the cell
combinations that make that number.
I picture it working like this: You highlight the cells you want to search
and then choose the function. The cell combinations are returned in a
seperate window and are limited to no more than 20 combinations. Once it
hits twenty one it returns a limit reached error.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions