Posts by azumi

• Count for unique criteria

Re: Count for unique criteria

Pls check the file attach, using array formula

• Unique list based on multiple columns

Re: Unique list based on multiple columns

Awesome formula XOR....

• Replace multiple alphabets from a text

Re: Replace multiple alphabets from a text

You can use SUBSTITUTE function

• Problem Using INDEX & MATCH

Re: Problem Using INDEX &amp; MATCH

put in J2 :

=INDEX(D\$2:D\$4,MATCH(1,(\$A\$2:\$A\$4=\$G2)*(\$B\$2:\$B\$4=\$H2),0))

and press CTRL+SHIFT+ENTER button all together, not ENTER alone, after that you can copied cross and down

• Vlookup & Index/Match

Re: Vlookup &amp; Index/Match

I see the file and nothing wrong with the formula, but the Order ID is nothing match (just 1) with other sheet

• Vlookup & Index/Match

Re: Vlookup &amp; Index/Match

try to upload workbook, click "Go Advanced" button, and then find paperclip image button to attach your file

• Compare 2 new values with 2 old values and display a result

Re: Compare 2 new values with 2 old values and display a result

To upload your sample file, click "Go Advanced" button, and then find pasperclip image button to attach it

• modifying a Vlookup Formula to an index match formula

Re: modifying a Vlookup Formula to an index match formula

Im not sure about what you're trying to do, try explain with sample workbook and described the desire results too

cheers

• Return all rows of table when cell in a column contains a date

Re: Return all rows of table when cell in a column contains a date

Try to show your expected results in your file for better explanation

• Dates and age

Re: Dates and age

Assumed the DOB start on B2 and down:

=IF(B2="","",IF(DATEDIF(B2,TODAY(),"y")=0,"",DATEDIF(B2,TODAY(),"y")&" yaers ")&IF(DATEDIF(B2,TODAY(),"ym")=0,"",DATEDIF(B2,TODAY(),"ym")&" months"))

and copied down as necessary

• Formula To Convert Months Into Weeks

Re: Formula To Convert Months Into Weeks

Not sure, but try this....

cheers

• Year and Months format and formula to calculate difference

Re: Year and Months format and formula to calculate difference

Yes it could be done but more longer formula you have, pls see this, iam adding formula and hope this works
https://simpan.ugm.ac.id/publi…ba1509eb1855db22a3cacdf65

regards
azumi

• Year and Months format and formula to calculate difference

Re: Year and Months format and formula to calculate difference

Pleasee see the file, hope this works....

• keyword search and return multiple values across multiple tabs

Re: keyword search and return multiple values across multiple tabs

Sorry for late reply, pls see this and hope this works

Regards

• keyword search and return multiple values across multiple tabs

Re: keyword search and return multiple values across multiple tabs

Ooops I dont' see your jockey name in there, ok got fix it.... pls see attachment, hope this works

• keyword search and return multiple values across multiple tabs

Re: keyword search and return multiple values across multiple tabs

Pls see the file attach, using array formula

• looking up a name withing sort of data w/out repeating the previous looked name. Tnx!

Re: looking up a name withing sort of data w/out repeating the previous looked name.

Maybe something like this? Using array formula, means you need to confirm press/hit CTRL+SHIFT+ENTER button together, and then copied down.

Regards
Azumi

• Lookup / Search / Find / Match / Approximate Match

Re: Lookup / Search / Find / Match / Approximate Match

Quote from MYG123;738676

Ok, the excel file is available for you at http://www.theirresistableoffer.com/excel.php

Thx

Check inbox, Im already pm you

• looking up a name withing sort of data w/out repeating the previous looked name. Tnx!

Re: looking up a name withing sort of data w/out repeating the previous looked name.

Perhaps something like this? Pls see the file attach

regards

• Lookup / Search / Find / Match / Approximate Match

Re: Lookup / Search / Find / Match / Approximate Match

Quote from MYG123;738492

I have sent a link to the sample workbook to all users who responded in a private message. Thx

Don't send to private message, to attach your file click "Go Advanced" button and find Paperclip button to attach your file.