wanted

  1. Geo1126

    IF Last month

    Hi Guys, I think this is pretty basic, yet I still havent been able to figure it out. I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA. A1 has date B1 has value I wanted formula to capture C1...
  2. M

    Rounding the months and days in between 2 dates

    I'm calculating number of months and days in between 2 dates (jan1 2019 & Dec 31, 2019) using a formula Value(Datedif(A1,B1,"M")&"."&datedif(a1,b1,"md")+1) and i am getting a result of 11.31 but i wanted to appear as 12 instead (since 31 completes the whole month). I want to get the real...
  3. L

    replacing = with '= works but not '= with =

    Hi I have several formulas in different cells. I wanted to show the formula not the value so I thought of adding ' to = I went to Home-->Find and replace--> = with '= It did work Then I wanted to do the reverse and replacing '= with = but I got error message saying could not find '= Is that...
  4. L

    How to combine values from 2 columns

    I everyone! i have a problem, I want to create a single column from the combination of 2 others from diferent tables... these columns have a null value or a numerical value, like this: COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE...
  5. P

    Error when loading form with spreadsheet object (OWC)

    I have upgraded Excel to 2016 and now get an error when using an older file with a spreadsheet object embedded in a userform. I think Microsoft Office Web Components 11.0 may no longer be supported, but I wanted to find out if there is another solution for displaying data on a userform that...
  6. T

    Help with multiple UserForm Optionbuttons: clearing and resetting

    I've been assigned a task in which I have to automate a survey that resets the option buttons when you click the "clear results command button". I wanted to know how do I clear the option button entries with multiple user forms which are ranged from E63:F88. Also, I wanted to know if its...
  7. R

    Office 365 Insiders Excel 64 bit Userform Date Picker

    Hiyas, I have a spreadsheet where there's a field in my table for a date. Currently, I'm entering in the date manually but, I wanted to try my hand at creating a userform with VBA and for the date, I wanted a date picker. Sadly, I've learned that 64 bit Excel doesn't have a built in date...
  8. E

    How to Print Selected Cells without changing its position in the sheet

    Good day guys! Please help me figure out what I need to do with this situation. I have a form ready for printing, but I wanted to just print a part of it only, example at the center of the page. I set the Print Area but then when I preview it, I found it at the top of the page. How can I...
  9. M

    VLOOKUP vs INDEX-MATCH

    I use vlookup all the time. For whatever reason it keeps returning #N/A on every cell. I can only suspect that the data that was provided is somehow messed up I want to try using INDEX MATCH instead of VLOOKUP to see if I get the wanted results. I have never use INDEX MATCH and would appreciate...
  10. T

    Conditional Formatting Formula

    I wanted to use conditional formatting to turn a cell red if a certain condition was true. The formula I wanted to use was a double lookup so I test the formula in an actual cell to see if it was working the way I wanted. Below is the formula...
  11. A

    How to split text string in

    Hi Awesome people, I need help please. What the formulato use if I wanted to split text. For example <colgroup><col></colgroup><tbody> 19,BMW,G02-X4,G02 - BMW X4 xDrive20i I wanted to use formula just to pick up G02-X4? Thanks AA </tbody>
  12. M

    VBA - Sort table by data ascending

    Hello forum, I hope you're all well. I'm in need of help as I've just not been able to figure this out. I'm looking to sort a table out through a macro. The table's range is B2:F30, where B2 is the table's headers. Column F contains the dates I require sorting. I did record a macro and...
  13. R

    Macro to concatenate multiple workbook in to single one. each workbook has 2 sheets. it should combine acordingly

    it should not copy the first row - contains heading which is same for all sheets .
  14. E

    Extract numbers from cell after 5th / character

    Hi All, Hope some of you clever folk can help me. I wanted to extract the number in the following URL, it is after the fifth "/", and before the "?": <colgroup><col width="87" style="width: 65pt;"></colgroup><tbody>...
  15. E

    incorporate date in IF/VLookup

    Hi there, I have a formula below that is working great so far. However, I wanted to add a date reference to it. For example if D1="03/29/19"....then apply the current formula below, if not just "" =IF(ISNA(VLOOKUP($B4,MARCH,10,FALSE))=FALSE,"NO","YES") It is not doing what I wanted to...
  16. R

    calculating 3 Year return with monthly returns

    Hi Everyone, First off I wanted to thank everyone for the forum... This place is awesome.. I am learning a lot thanks to all you guys!!! I have monthly returns and wanted to calculate a 3 & 5 Year annualized return. Could anyone help me? Please see attached 31-Jan-14 0.71 28-Feb-14...
  17. S

    Complex CountIfs with Sumproduct...

    I've never used SumProduct before so I've cobbled this together after a bit of googling. The Sumproduct works great and reports what I would expect but I need to eek out more to get what I need. Here is the formula that I wanted to use..... =COUNTIFS(O:O,0,Q:Q,"No",R:R,"<" & N:N)...
  18. E

    Concatenate and If together for Carriage Return

    I am trying to create a formula for a table that contains two street address lines, City, State, Zip. If there is one street address line, I wanted to suppress the Carriage return. If there are two address lines, I wanted to incorporate both lines. I can conceive using the Concatenate and If...
  19. D

    Copy & Paste X number of times but with certain conditions

    I copied most of the code below from somewhere and modified it a little and it basically works how i wanted except for some conditions that I wanted to add :( The original code with slight amendment and which works is below: Option ExplicitSub INDO() Dim arr As Variant Dim wsO As...
  20. A

    #VALUE! disabled!

    =Y3*Z3*1.3/100 Hello what is the way to add on that formula if I do not wanted to see #VALUE ! if there is no data on related cell with formula. Thanks

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