I have four columns. One has an account value. associated with each account is an amount column. Sometimes there are three accounts sometimes two. Then to the right is a column that contains a new value. I need to find which of the original amount value is closer to the new value.
there can actually be many acounts not just 2-3.
Here's my shot at it using a UDF.
=IsCloser(Account, Target Value, Account Range, Amount Range)
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
When i tried that i got a #NAME?. Any suggestions?
Account and target value should be single cells and Account Range and Amount range should be actual ranges on the worksheet like so:
=IsCloser(F2,H2,$F$2:$F$8,$E$2:$E$8)
ya i have it set up like that. Even when I look at the example you posted it still has #NAME?
I don't know what to tell you. When I open the workbook, it works. The only reason to get a #NAME error is if excel doesn't know of the function name or the name of one (or more) of the parameters. I don't think that if you fail to enable macros you would get a #NAME error - you would get some other kind of error.
I see. I am on excel 2010 so that might make a difference. When I first look at your example it looks to be working. But when i enable editing it switches to #NAME?
Also i was not using any macros. should I?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks