eft

  1. G

    help with if or formula

    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>...
  2. G

    If or help

    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>...
  3. P

    VBA Virtual Loop

    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...
  4. P

    VBA Coding between the lines!

    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...
  5. P

    IF formula imbedded with concatenation

    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...
  6. P

    Pulling formulas down.

    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...
  7. M

    Count only unique rows with a single matching value

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top