suspect

  1. C

    Formula help needed

    Would anyone know the formula when copying down rows from row 1 it does the following: - where x can any positive number, e.g. if x = 4, the following from row 1 down would be 1 2 3 4 1 2 3 1 2 1 "" "" etc. e.g. if x = 3 1 2 3 1 2 1 "" "" etc. I suspect you would need the function row() and...
  2. kweaver

    VBA: cancel file selection

    I have a macro that prompts a user to select a file that is subsequently saved as a sheet and the data used in calculations. If the user cancels at the prompt to select a file, how do I avoid an error and just exit the macro? I suspect it's something to do with OnError, but don't know the...
  3. J

    Database - search,analysis and return results

    Hi, A query first before i put up my database for example. I want to search my database and return the value ( Profit ) for all possible combinations. ( Combinations could very well be into the 1000's ) there are 7 columns from the database where all combinations can be chosen from, in each...
  4. E

    VBA Windows Object

    I've been given the responsibility to fix a broken macro of a termed employee. This individual used the code listed below but I don't understand he used the Windows object rather than Sheet object. Is there any logical reason to do this? I suspect there must be a reason that I'm not aware of...
  5. matthewlouis

    INDEX and MATCH is one row off

    I am doing INDEX and MATCH to find a date in a source table that matches and returns a percentage in the table I'm using. The table where I am doing the INDEX and MATCH has 48.20%. So I'm indexing the date that matches that 48.20% in the source table (see below) and it says 3/7/2019. I know...
  6. matthewlouis

    INDEX and MATCH confusing error (?)

    I have the following INDEX and MATCH formula . . . =IF(C31="Confirmed Sideways",INDEX('D1'!$Q$1:$Q$100,MATCH(F31,'D1'!$S$1:$S$100,0)),IF(C31="Suspect Sideways",INDEX('D1'!$L$1:$L$100,MATCH(F31,'D1'!$N$1:$N$100,0)),IF(C31="Confirmed...
  7. D

    Email Range Of Cells

    Afternoon All, i'm after some help in emailing a range of cells depending on which cell changes to "on suspect list" See example below. A B C D <colgroup><col...
  8. R

    On error and paste.special

    I have a sub which starts with an On Error GoTo and then continues to use a PasteSpecial. (I can paste code if required, but I suspect there may be an easy answer from someone here!) Now if there is nothing to paste it does not go to the label but just stops at the PasteSpecial. I suspect this...
  9. K

    text date & time conversion help

    I have a report where the cells are in text in this format "2018021409012900" it is YYYYMMDDHourHourMinMin. The last four digits are milliseconds which I don't need. I need to convert this to a date & time cell that is more legible. I can think of some labor intensive ways to do this, but I...
  10. A

    How does Excel treat numerics differently

    I am testing one value as a multiple of another and suspect that they are stored differently. I have a routine accumulating money values in various denominations. There is a text box for each coin denomination ( eg 50 cent,20 cent, 10 cent etc) called tb10cents, tb20cents etc. I wish to prevent...

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
Back
Top