Marcol
Forum Guru

Dear Marcol

Here is the link to the original thread.
http://www.excelforum.com/excel-gene...ss-sheets.html

here is my email: webmaster@brodieball.com

Again THANKS for YOUR TIME

Dear Marcol.
Thank you for all your help but I am in a bit of a quandary see below.

Re: Inserting Rows across sheets

--------------------------------------------------------------------------------

I have another issue with this sheet Marcol, I have a complete new sheet of People that in in essence going to be tha (all) sheet. I need to compare the 2 sheets and add any new ones to the list. I then need to take the names in tha (all) sheet recompare and those names that are not on the new list need an addendum in the notes line of there info stating "no longer LT but has training"

ras408@yahoo.comDear Sir,

I Ram Avtar Singh facing problems in Excel conditional Index match command. i need your help. but there in no file attachment option. kindly provide your Email so i can send my file and find solution of error.

=INDEX(Data!$C$2:$C$498,SMALL(IF(Data!$B$2:$B$498=$C$17,ROW(Data!$B$2:$B$498)-ROW(Data!$B$2)+1),ROWS(H$17:H22)))

when no other entry then formula giving #NUM!. kindly help me.

my email id is ras408@yahoo.com

Hi Marcol,
Many thanks for your help on my post
http://www.excelforum.com/excel-gene...-criteria.html !

However, on my original file it still does not work ;-(. This problem really gives me a headache to be honest.

Would be great if you could have a new look. I posted a reply on the original post, but also made a new one in case that would be more handy (http://www.excelforum.com/excel-prog...ml#post2607577)

Really appreciate your help... There needs to be a way to solve this right?


Many thanks!

Best, Alinda

Hi - It must be too early for me - need more coffee?
Want to stab at this one?
http://www.excelforum.com/excel-work...s-formula.html

It feels like a countif with a Row() somewhere in it would work, but I'm giving up. I don't need the whole calvary, just a sanity check.

Hi Marcol,i need your help about how to copy table to other excel file,and if the table from the master edited,the copied table on other excel file automatic update (include added row)...

Thanks

Dioni

Hi Marcol,

Thanks for your help on my previous problem. I have a new problem i need your help on..i have posted it in the forum under the heading" Need to show value as NA" can you please help me on this...

Hi Marcol,

Would love to chat with you about a new venture - it's an expert Excel network that I believe to be complimentary to the forum experience (non-competitive). Would like your input if you have a few minutes.

Best,
Josh
josh@qwiktalk.com

Marcol you are so helpful! Many thanks

Thank you so much for explaining one of the responses someone posted to my question. Without your detailed and very informative explanation, I would not have understood the response at all. You were a HUGE help.