Hi Joey, for excel formula use =IF(AND((C8-B3)*24*60>=1,(C8-B3)*24*60<=4),0.5,IF(AND((C8-B3)*24*60>=5,(C8-B3)*24*60<=29),1,IF(AND...
Use Power Query is easier Attached example
Hi Cindy, if you only want to show total product purchase, just put your cursor inside the range, CTRL A, home -> format as table. From the ...
Hi Damali The quick way will be select Cell A5499 downwards, Ctrl H, replace "-" with blank and you are able to sort it Cheers !
Hi Miguel, Thanks for sharing this method of Vlookup + Choose which can solve a lot of pain for users that still insist to use vlookup, however suf...
Hi Mynda, Created function ( not sure whether is correct) (Input as table) => let Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],...
Hi Mynda, I saw this blog this morning and it seems quite complicated and thought you all got another alternative 🙂
deji, not very clear on your requirement can you upload a sample of the desire result that you want with the source tables ( the vlookup tables ...
similar to the case in this thread when they use DAX calculate just wanted to explore any easier way (for biz user) to use PQ to achieve the sa...
Hi Catalin, got it thank you very much
Hi Catalin, I did combine with edit Encounter error for the second excel Oct 19 An error occurred in the ‘Transform Binary from Listing’ quer...
Hi Catalin, I was not familiar with query from File> From Folder manage to put Oct 19, Nov 19 to a folder In the query ContentNameExten...
Hi Catalin, ooh, have not tried from folder yet. so I put Oct 19, Nov 19 inside the folder, Append them and whenever there is a new file Dec 1...