I currently have a worksheet that contains a large amount of data with account titles and total charges to each account. What I've defined certain threshold levels that the user can use to generate a dynamic drop down list.
I'm trying to read through the spreadsheet and return the appropriate account if the threshold is met.
I have
=IF('GP 2004-2006'!AO3>Charts!$E$39,'GP 2004-2006'!D3&" "&'GP 2004-2006'!E3,"none")
Where Charts!$E$39 is the threshold value. I'm using this same formula down the range of total values, as you can imagine, I'm getting a lot of account numbers as well as the word none
What I really want is to somehow search through the totals and return all the values that are greater than the user defined threshold.
I've never done any VB or macro work before. Is it possible by using pure Excel without macros or VB to accomplish this? Or will I have to create a macro for something like this?
Any help would be greatly appreciated.
Thanks,
Yun
I'm trying to read through the spreadsheet and return the appropriate account if the threshold is met.
I have
=IF('GP 2004-2006'!AO3>Charts!$E$39,'GP 2004-2006'!D3&" "&'GP 2004-2006'!E3,"none")
Where Charts!$E$39 is the threshold value. I'm using this same formula down the range of total values, as you can imagine, I'm getting a lot of account numbers as well as the word none
What I really want is to somehow search through the totals and return all the values that are greater than the user defined threshold.
I've never done any VB or macro work before. Is it possible by using pure Excel without macros or VB to accomplish this? Or will I have to create a macro for something like this?
Any help would be greatly appreciated.
Thanks,
Yun