Recent content by Kutty

No. The cell have some data. If possible, then I will make the condition format to make colour the diagonal portion.

I try to fill within cell diagonal line

Is there any other options without code

Hai Friends, How to fill the number up to particular repetition with more than 3 conditions (including Time also). I attached herewith my excel file for your reference. Thanks & Regards, Kutty

Thank You So much @Luke M for your help. It's very helpful to me. You done exactly what I want. Thanks a lot. by Kutty

Hai Excel Experts! How to make drop down list in many rows except the selected name in the previous cells. I attached herewith my excel file for your reference. Thanks. by Kutty

Hi Chihiro Thank You so much. Your work sheet is so helpful to me. I don't know VBA. But here after I would like to learn. Thanks a lot.

Hi bosco_yip Thanks for your workout. It has so many named range. I have try to avoid many named formula. If above 500 bio-data and Photo, it may not possible. That is why I am asking any other method to eliminate so many named formula. Thanks

Hi Chihiro I accept it. Thanks.

Hi @Peter Bartholomew This one is what i want. I think without VBA its impossible.. :confused: Thanks for sharing this spreadsheet.

Hi Peter I'm not understand your formula

Hi @Chihiro Sorry for that inconvenient. Here it is the sample file.

Hi! I retrieve picture, using Index & Match functions. I have picture data in one sheet & contact details in another sheet. If we retrieve the picture in one row it may possible. But I want picture so many rows. It may be want so many named range. Is there any other way to do solve this problem?

I'm surprised to see everybody posting their formula in different view. Thanks to Excel Ninjas.