Search results

Hi All Excel Ninja's, Please help me with the date updating with the help of formula, where i update this tracker daily. 1). when i update the Date of order column, there the date should be blank when G column is Done and should not be date value when its Not Done. 2). when i check the...

Hi SirJB7 sir, this is the 2nd time u are helping me thanx a lot but its really helpful now...:)

Hello KPJ Sir, Please let me know how to do that index match as well will be honoured to know that technique also :)

sir as u said that these two columns are from different sources so in that case i have the problem on sorting...

sir i am really sorry for the confusion but now the these column doesn't look same. What i need is if i use sort both the column should be true when i put =(reference)=(reference) if col A is jumbled then the col B should be jumbled in the same order as col A.

Sir, i don't need that in order like a to z sort, but the sort how it is in col A like the jumbled/replaced numbers.

thanks for your quick response sir but i need to order the col B which is similar to col A in the sense when sorted both should look same, which i will be working on this for 1000's of data so please help me sir.

dear sir, i have a problem on sorting the table like in example below col A Col B 1212 2121 2121 1212 2323 2121 2121 2323 2525 2545 2545 2525 2565 2145 2145 2565 now i need col B...

Sir Mind Blowing Superb thanks a lot Huuuhahaa!!~ sir please give me ur skype or and gtalk ID so that i can chat with u for more information...

yea sir i have shared my File by adding u in the file sharing settings

sir i am done with the sharing settings please check sir

@SirJB7 Please look to the below link and please check with the past comments i need help on conditional formatting https://docs.google.com/file/d/0B9Hkz2Emr9enWW9tU3BHejd6aVE/edit

some body please help me :(

@Debraj Sorry but u have posted the same. Ok here is quick reference 1. I used to update the tracker regularly. 2. When i update and if i get a value "duplicate" and not the "not a duplicate" then only "duplicate" value which i have updated should highlight not the other one. 3. I have...

Great Forum for beginners Chandoo sir keep it up!!~

Thank you friends for your quick response. But what i meant is i will be keep on updating data day by day and in that data i need only duplicates to be highlighted not the other's so both the formulas dint work properly please suggest me if there is another formula's

now i have some data and some ID's but i need to check the ID's which are duplicates and i use the below formula to find duplicates i.e. more than one ID it shows the value if true/false and this i will be updated the ID's regularly and i autofill the data regularly. So please help me how to use...