iceman_574_98
New Member
- Joined
- Oct 26, 2010
- Messages
- 2
i was trying to use
{=IFERROR(INDEX('Total AR'!$B$1:$B$9999,SMALL(IF($A$1='Total AR'!$A$1:$A$9999,ROW('Total AR'!$B$1:$B$999)-2,""),COLUMN()-9999)),"")}
In which Total AR Column B has a unique number in it, Total AR Column A has either AR or EXPENSE or OTHER in it.
on my current sheet A1 i will enter either AR or EXPENSE or OTHER and i want in A2 through A60 for it to get each one of the unique numbers from my Total worksheet that match the entry i put in A1.
So that i put AR in A1 , i would put formula in A2 that would bring over the first unique value from total tab that has AR in column A on the worksheet, A3 would have the next unique number and so on.
{=IFERROR(INDEX('Total AR'!$B$1:$B$9999,SMALL(IF($A$1='Total AR'!$A$1:$A$9999,ROW('Total AR'!$B$1:$B$999)-2,""),COLUMN()-9999)),"")}
In which Total AR Column B has a unique number in it, Total AR Column A has either AR or EXPENSE or OTHER in it.
on my current sheet A1 i will enter either AR or EXPENSE or OTHER and i want in A2 through A60 for it to get each one of the unique numbers from my Total worksheet that match the entry i put in A1.
So that i put AR in A1 , i would put formula in A2 that would bring over the first unique value from total tab that has AR in column A on the worksheet, A3 would have the next unique number and so on.