LinkBack URL
About LinkBacks
I am using this formula but am trying to get results without duplicates. Can it be done?
{=IFERROR(INDEX('All Cases'!$B:$D,SMALL(IF('All Cases'!$B:$B='Summary Sheet'!$D$7,ROW('All Cases'!$B:$B)+2),ROW(A2)),2),"")}
I am using this formula but am trying to get results without duplicates. Can it be done?
{=IFERROR(INDEX('All Cases'!$B:$D,SMALL(IF('All Cases'!$B:$B='Summary Sheet'!$D$7,ROW('All Cases'!$B:$B)+2),ROW(A2)),2),"")}
@ Mahalek Can you upload a sample book. As to understand things better
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
The forum will not allow me to upload. The file is too large
'All Cases'!$B:$B what is this is it number of text
Summary Sheet'!$D$7 is it number or text
It is numbers that I am pulling out. That I the formula in my original post that I am using. It does exactly what I need it to do except it brings over al of the numbers associated with the criteria including duplicates.
You must be able to upload a small file with < 100 rows.
Make up a SMALL file that demonstrates what you want to do. 20 rows worth of data is plenty.Originally Posted by mahalek1976
We don't need files with 100's or 1000's of rows and dozens of columns worth of data. That just makes it harder to come up with a solution. Having to test it against all that data is not easy!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Here is a small version of my spreadsheet. The formula is in F7 on the summary sheet. Thank you for your help.
in that case for Bott, Jeffrey N you will have only 1st october 9 december and 13th december 2015, is it what you are looking for
No. Sorry. I am only looking to return the case conf number. I don’t care about anything else. I will bring everything else in later.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks