Search results

sorry hui and debraj sir echo was in CMD prompt :( i mean the box pops to input values. i wanted to know how it triggers :(

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/

Great thank you sir you made my day :)

wow awesome sir between can u please explain me the above formula. if you dont mind.

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

wew... awesome sir thank you for both of you sharing ur time solving my problem.

Hi sir, is this the same macro which narayan sir explained above?

Sure Sir. Please check the link below. https://www.box.com/s/pu118ynf67rlcpes5n9f

Oh... thanks a lot Narayan and Suresh sir. But sir i have another files which has a criteria like second statement so i need a macro for them as well.

hi Sir, thank you for your quick response, as u said above i have created a sheet called Master and when i run the macro i am getting 400 error code. and please let me know how can i combine sheets if the sheets consists with Merged cells and i need only the unmerged cell's content. it's in...

Hi Sir, Can u please check the below link. https://www.box.com/s/od5hij5yazony551299v

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

but i couldn't find the source any where sir... :( but in Alt + E + K i have 1 link which cannot be breaked.

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.

hello bobhc i just suggested these thing and am not forcing to create

but how come others know that the name credits which indicates whether they are online or not... so a status indicating dot would be fine.

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

Thanks a lot sir but...1 thing how can i do this using INDEX and MATCH Function???

Hi suresh its repeating the same value i mean it fetches the 1st value all over the place. :(

1 last chance :(. please try below link and sorry for the interruption :( https://www.box.com/s/bunzv39xlapgm4gkw1yx

Try this 1 Suresh https://dl.boxcloud.com/bc/1/074eedf6b15ba9537be895a33d585248/JolueqOGpciD6dgYhecNBoVpYxkvmYe1ZLheZor6BF4DUBIelMQTkFwYIys3nIibNIIEHUp447tBZLaXDzIbNQ,,/e02eeba3daf9b7357cdff80cf5a1e2f2/

Hi Suresh please check the below file for the data and the function which i have used https://www.box.com/files/0/f/0/1/f_5881131663

Hi Suresh its column B in Sheet 2 where i gonna paste the formula

Hi Debraj thank you for the quick response. But here i am getting NA error now what to do?

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