Hi thanks for the reply. I think I have attached my sheetozgrid.com/forum/core/index.php?attachment/1232288/]]>

Hi thanks for the reply. I think I have attached my sheetozgrid.com/forum/core/index.php?attachment/1232288/

]]>Doing well.....Thanks]]>

=INDIRECT("JCB!B"&MATCH(9^9,OFFSET(INDEX(JCB!1:1,INDEX(MATCH(Display!$I$3&Summary!$M$8&Summary!$M$6,JCB!1:1&JCB!2:2&JCB!3:3,0),0)),,,60000)))

Doing well.....Thanks

]]>I've converted the column of dates to an Excel Table so that you can add or remove dates and the formulas will still work.]]>

I've converted the column of dates to an Excel Table so that you can add or remove dates and the formulas will still work.

]]>C (from C), D (From D), E (From F) L (from I) and P (From H)

However, In the asset data tab where we need to identify the correct entries to pull the date from using…]]>

C (from C), D (From D), E (From F) L (from I) and P (From H)

However, In the asset data tab where we need to identify the correct entries to pull the date from using both the ISIN (A) and the Register holder (G) as there are multiple holders for the same isin.

So on the distribution tab ISIN (N) and Unitholder (G) need to match the ISIN (A) and Registered holder (G) on the asset data tab and pull through the corresponding information.

I have tried an Index and match but it never works for me. Any help would be really appreciated!!

]]>My apologies for taking so long to thank you for your help, I should have done it earlier..

I'll try harder in future...

Kind regards

DezB]]>

My apologies for taking so long to thank you for your help, I should have done it earlier..

I'll try harder in future...

Kind regards

DezB

]]>As you can see the final digit is repeated on it's own. Try

…]]>

{"71";"15";"54";"45";"57";"77";"78";"85";"50";"08";"81";"10";"08";"8"}

As you can see the final digit is repeated on it's own. Try

=MAX(FREQUENCY(0+MID(A2,ROW(INDIRECT("1:"&LEN(A2)-1)),2),0+MID(A2,ROW(INDIRECT("1:"&LEN(A2)-1)),2)))>=3

]]>Why do you think you need code? Excel's inbuilt functions are more efficient than code.]]>

Why do you think you need code? Excel's inbuilt functions are more efficient than code.

]]>You don't need the search word in a TextBox just use a specific cell.]]>

You don't need the search word in a TextBox just use a specific cell.

]]>I am working on a list that contains data that has to be matched with another file.

If i match the number on the other file i have to get the outcome of a different column on that same row.

However there will be multiple matches on the other file,…]]>

I am working on a list that contains data that has to be matched with another file.

If i match the number on the other file i have to get the outcome of a different column on that same row.

However there will be multiple matches on the other file, some with the same outcome. I need to only get the unique outcomes and nothing i tried worked so far.

Can one of you excel magicians help me out please?

See attachments for an example, i am trying to match example 1 with example 2.

Many thanks in advance!]]>

=SUM(COUNTIF(A2,ProjectCode))=0 where "ProjectCode" is NameRange]]>

=SUM(COUNTIF(A2,ProjectCode))=0 where "ProjectCode" is NameRange

]]>=SUMIFS(INDEX(Data!$D$4:$H$13,,MATCH(C$5,Data!$C$1:$H$1,0)),Data!$A$4:$A$13,$A6,Data!$B$4:$B$13,$B6)

ozgrid.com/forum/core/index.php?attachment/1232142/]]>

=SUMIFS(INDEX(Data!$D$4:$H$13,,MATCH(C$5,Data!$C$1:$H$1,0)),Data!$A$4:$A$13,$A6,Data!$B$4:$B$13,$B6)