Search results

Hi Narayan, Thanks for your quick response. Yes i want like that. However count of ageing mismatch is there. Example below Negative more than 180 is actually 1 only, If i use helper column it will become 2 only. I need help on this. Negative More than 180 3 Second, Ageing status you...

Hi Friends, Need help!!! Attached excel file for your reference. 1. Based" no of days" pending need to lookup or fill (formula) ageing status. 2. Based on status count no of ageing and distinct nonid . Example also there.. Thanks Syed

Hi Friends, I need a macro to hide column which is contain Particular text like "syed". Attached file for reference.

Hi, VLOOKUP will work. I don't know why it is not. And one more information in your excel workbook calculation manual enabled change to automatic and try your formula.

Thanks, This is what am looking for. thread (closed) :)

NO... What you are doing that's correct . But you see my file 92 code have 2 rates but unique is 1 only so it is duplicate. 92 code having 1 value only.

No this not correct answer. if you see in excel sheet. 91 code is in 3 times rate also 3 times. but 92 code is in 2 times but rate is only 1 unique values. you modified my question itself?....

Hi, PFA. I have shared file with required answers. Kindly advice on this.

Hi, Please attach sample with file with expected result.

am extremely sorry wrongly uploaded file .

And it is my mistake for summarzied my question properly @vletm Result. Edit: While using INDEX MATCH am facing REF! error. I don't know why it is occurred. Not urgent kindly look into this. Thanks respected @vletm

I found result thank you ....

Hi, I have attached with another sample, i have same value but it is not in order (asc or dsc) You can see in attached file. I want to compare this.

Hi, How to compare two pivot tables. Or how to pivot two pivot tables??? Attached sheets for you reference.

PFA ARRAY FORMULA

Ok What you going to show in X Axis

Thanks to everyone........... :)

Super, Without exact match....!!!!

Hi frds, Any ideas kindly help on this. Please find attached document, i have explained.

PFA

Him My try

Hi, I have data in excel sheet. 1.Header are same 2.Different city wise excel sheet data I want use pivot table to summarize all sheet without consolidate this in to single sheet. I want to us Multiple consolidation range. I did that but am not able visualize like attached pivot sheet...

Hi, Thanks this is nice one.... But i know this solution using helper column. I need to know any possibility of getting Data Validation without helper column. Am faced on interview with this question ...

Hi, I want use data validation to list the name but unique values alone using formula. Attached example for you reference.