eft

good day thanks for looking do some can see whats wrong with this formula it seems that I have been watching it too much and can't find the issue for not working =IF(OR($B48="Withdrawn",$B48="CREDIT CARD"),IFERROR(VLOOKUP($Y48,'EFT Information'!$A:$L,13,0),"Not EFT"),"Not EFT") <tbody>...

good day thanks for looking do some can see whats wrong with this formula it seems that I have been watching it too much and can't find the issue for not working =IF(OR($B48="Withdrawn",$B48="CREDIT CARD"),IFERROR(VLOOKUP($Y48,'EFT Information'!$A:$L,13,0),"Not EFT"),"Not EFT") <tbody>...

Hello, How do I write code to move on to another question if the information doesn't exist on my spreadsheet? My code is: 'Select Start of range Range("B1").Select While ActiveCell.Value <> "" 'This writes 'Cash' in column A against cash transactions. If ActiveCell.Value <> "" Then...

Hello, How do I write a code to highlight everything, including the blank lines? I need to highlight and copy everything in B1:E7, and I seem to be stuck at just highlighting B1:E2. ActiveCell.CurrentRegion.Select isn't giving me much joy. I'm stuck in a virtual loop! Thanks for your help...

Hello, How do I write a formula to: 1. Determine if a cell is labelled "Cash", "Cheque" or "EFT" 2. If it is then I need to concatenate certain cells together. Example: Thanks for your help. Best wishes, Peggy <tbody> A B C D E F 1 Cash Stationery {formula = }Cash - Stationery 2...

Hello, How do I write a code that pulls down formula in column D and stops after searching for information when it reaches "Report Total:". <tbody> A B C D Cash [insert formula] cash [insert formula] Cheque [insert formula] EFT [insert formula] EFT [insert...

What is a DAX formula to count only those rows that have just one corresponding value in a column? We can pay vendors in 4 ways - EFT, and 3 types of checks. DISTINCTCOUNT() will give me all the vendors we paid by EFT if I filter by payment method but it doesn't tell me vendors who *only* paid...