Search results

I think you can overwrite formula with Ctrl+H(selected cells) and replace them to your needful information whether it is Need information or Missing information

Congratzzz bobhc for 1k'th post(s)....

thanks a lot sir, it helped me a lot

dear all, i have a doubt on massive data.... like if i have a data of 10,000 which contains numbers 1 to 10,000. in this how can i find a/certain number(s) which is missing between the order.

Thanks a lot Hui sir u made my day easier but it would be easier when it automatically save right. is there anything like that we can save it to quick format toolbar

good day sir, but what i need it legend colour's in same patterns like 1. red 2. yellow 3. pink 4. brown the same way it should there for each and every graphs/chart created by me so please let me know how can i do this.

I need a same patterns(customized & changed) for my excel chart. Please tell me how can i do this.

you are awesome thnx amrit

Hi Kaushik, what i need is a formula which includes IF and CONCATENATE, where IF should contain 2 criteria in Logical_Test & CONCATENATE should be in [Value_if_true],the 1st criteria as [Value_if_false]...

Please help me with Concatenate and if(with 2 criteria's) =CONCATENATE([@Status],[@[Sub Status]]) the above 1 is use... now what i need is =if([@Status]="asd"&[@[Sub Status]]="zxc",=CONCATENATE([@Status],[@[Sub Status]]),[@Status]) i need a formula format like this...

@sgmpatnaik awesome ty a lot... u really saved my day ty :)

but sir is there anyway like without helper column or without the second value column i need it all in the same i.e. Product keyword column. please help the needful.

ha-ah as expected i have got the guidance from key master ty sir...

Hi Excel Ninjas, i am using the below formula for a sheet but when the lookup_value has same value again and the next column has different value its taking the 1st value into prior. please help me with this. =VLOOKUP($A2,[mm.xlsx]Sheet1!$D:$O,2,0) Product code Product keyword TIRP - 440...

@hui =VLOOKUP(LARGE($D$1:$D$20,3),CHOOSE({2,1},$B$1:$B$20,$D$1:$D$20),2,0) this is the actual formula... but i still not getting why is it used... :(

oh actually i also dont know why is that here. But i dont know what other type of parenthesis supports for this formula... can u please suggest me or explain y is that index_num needed

Hi All excel Ninjas, can anyone please tell me why is index_number should be {2,1} and why is it needed, how can i write formula using this? and if i give one number like {1} why it doesn't work? Syntax : CHOOSE(index_num, value1, [value2], ...) My Formula : CHOOSE({2,1},$B$2:$B$10,$D$2:$D$10)

sir thanks for your quick response... but 1 point i.e. my settings is under automatic calculations only and the range is around 15k data till date :) will try with this vlookup formula and 1 more thing how can i auto update filtered columns this happens when i update new set of data and...

Hi All Excel Ninjas, Can i know how to auto-update a vlook up without using a macro... because i will be updating excel on daily basis so i need a better solution for auto-update.

oh Kool sir thnx for your quick response :)

can any one please tell me how to autofill left column like for filling down wards > Select cells and press ctrl + D for filling right side > Select cells and press ctrl + r but what is the shortcut key for left column filling....

@Faseeh Actually sir i dont need a helper column for this please let me know if i can do this through any formula or some other Macro with a helper column.

@Faseeh Sir, thanks for your quick reply. I will try once on this macro and let you know...

thanks for your quick reply sir... but now forget about col B completely... what i need is when i update the tracker and if G column shows "done" then the col A's date should be blank and when its "Not Done" then it should enter the existing day's date. And when i see the same file tommorrow...

still no one answered my query :(