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
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 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!
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?
This post is a response to the previously asked question. But mine is without array formula.
https://chandoo.org/wp/2017/10/03/number-has-repetitive-digits-formula/
I expect this type of formula with particular product
https://stackoverflow.com/questions/15285381/excel-formula-to-sumif-date-falls-in-particular-month