wanted

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

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

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

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

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

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

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

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

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

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

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>

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

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

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

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

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

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

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

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

=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