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