Hello everyone,
In the Excel 2010 sheet attached, I have a tab called "Summary" with the formula: =LARGE(INDEX(('Tony Breau'!$V$3:$V$24=$B$5)*'Tony Breau'!$P$3:$P$24,0), 1), to solve for the largest account called within the week. $B$5 has the weeknumber of today(). And the formula refers to that. This function is also applied to "By # of Employees".
My problem right now is getting the Account Name. In the "Tony Breau" tab, the revenue and total employees of some companies are identical, so when I do a lookup formula on these numbers, it always shows the first one of the list. I was wondering if I can refer to the cell that formula =LARGE(INDEX(('Tony Breau'!$V$3:$V$24=$B$5)*'Tony Breau'!$P$3:$P$24,0), 1) is referring to so I can offset it left a few units.
Any help would be greatly appreciated! Thanks in advance.
Bookmarks