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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top