Search results

Hi All, i need a help on file which is in below given link. https://app.box.com/s/8muubfilwvmz0fmfx383 When i select data validated value in role column which is in Sheet1 it should only the role related task where the table in SRC sheet. This should be a formula or a macro.

Hi All, i have 2 columns with values and i need it to calculate as percentages. like, if A and B Column has 100 and 50 then i need it to calculate as 100% and 50%. Please help.

Hi All, i have below macro using. But what i need is instead of giving the keyword like Extreme, medium, low or something. can anyone please let me know how can i use aggregate percentage for each cell... like given on below given condition and i need to make 4 columns like a, b, c & d at...

Hi all, I am using below macro to remove Document Properties, Personal Information & Custom XML Data. but what i am facing is when i run this macro all the .docx files will be as same extension. But when .doc and .docx will be mixed in the folder then it automatically changes .doc file...

Hi All, Please help me with below find, which has Highlighted cells like option A, B, C & D. so when Option D is highlighted i need the Cell Value of it in Column Answer Key. same follows to each and every rows. https://www.box.com/s/xf8h8qujh7mnsjxclw6n

Hi All, Please let me know how can i insert a picture inside a cell i.e. Pressing F2(edit mode) and inserting. Thanks in Advance,

Hi all, The file in this link has echo feature but can i know how to do them using VBA? http://chandoo.org/wp/2011/08/30/variables-conditions-loops-in-vba/

Hi, i have a file with 4k of data which has warped cells with 2 lines in it please help me with making it 1 liner so that when i copy and paste it to external source it should be in 1 line. Please find the below file for sample data https://www.box.com/s/6pyl2ywhnhsv6rht6pb8

i have document which needs to be consolidated in one Sheet called Master. Please find the data file below which has 305 tables with same columns but the rows Number change...

Good Day Everyone, i am facing a problem with a file which is prompting me to Update or Dont Update from external source and now i dont have a source file nor i cant Delete/Break the link. Please help me with fixing this problem.

i have some suggestion which i wanna share with moderator's/site admins. 1. A poster should have all option whether its modify or delete a post. 2. A status indicator for all the users whether the person is online or not. 3. Private inboxes to send/receive the message when away which is...

Hi all, I am using below formula to lookup value which is in left column of Sheet1 but this is fetching the 1st value and the second repeated lookup_value is showing the 1st value which is in main source data. Please help me with this...

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.

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

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...

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...

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)

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.

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....

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...

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...

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...