Search results

So i guess no solutions here so im close this thread

The rule is if there is the number on range B2:F7 within 2 dates on columns header then return row header, hope its clear now

Thanks @vletm but when I change the date the result doesn't change, its possible without column helper? thank you

Need assistance from you again ninjaz please take a look at the file

Thank you @pocoflyer for help the answer, yes Sales C is wrong, but what formula when the data is not sorted

Hello ninjaz glad coming back here and need your assitance for clear explanation please see on the file attachment thank you

Hi Ninjaz need assitance again sorry to bother you guys again, please ghelp thank you

Thank you @p45cal , @Peter Bartholomew and @bosco_yip , thank you Ninjas Godbless you All

Oh sorry I misunderstood that the result should be the last number from multiple columns with criteria not maximum number Still need your help sir how to get the last number and date using criteria thank you @p45cal

Thats for date? Yes it works but how for maximum number? Still address wrong maximum number

Sorry @p45cal need help again, I try the formula on my actual workbook and the formula failed to do htheir works

Thank you @p45cal it works, thank you man

Glad Im here again and desperate need s help from you guys, please take a look at the file tghank you in advanced

This is double post https://www.excelforum.com/excel-formulas-and-functions/1341242-grouping-data.html and still no answer, please need help and take a look at the file for clear explanation and need formula solution (Im using office 2019 Thank you

Thank you @rahulshewale1 its awesome you nailed it thanks again for the helping

Is it possible a solution with formulas? Thank you in advanced

Sorry not mention earlier about myexcel version is 2019 but appreciate your help @rahulshewale1 thanks

I am still confused about whether the title is correct or not, but please take a look at the file, hope somebody out there understand and need formula solutions only thank you

Thank you @p45cal but i dont have excel 365, There is old school excel formula for this? Thank you for the feedback

Thank you @vletm its workin'

No That is not what I meant, please see the picture and look after row 21 the cells is completely gone

Or if you need excel file

I once found a workbook file on the internet and I was interested in removing cells there, cells completely gone, but i have no idea how this can be done, need help you guys, for better explanation please take a look at the file. thank you

Yes the results is COlumn A based on Column B and C

Have a nice day people, have problem with this numbering for duplicates, Im explain on excel workbook, please take a look at the file thank you Kenshin