suggestions

Hi, I am trying to have a macro evaluate column D which has dates listed, however, several in which are 1/0/1900 which I want to replace with nothing. Does anyone have any suggestions?

I made a very simple macro. Sub Yellow_Highlight() Selection.Interior.Color = RGB(255, 255, 0) End Sub I then assigned it a shortcut key of CTRL+SHIFT+H When I run the macro using F8 or Visual Basic it works fine. When I try to use the shortcut it does not work. Any suggestions?

I need to rank between 2 tabs in 1 workbook. I can rank between 2 columns in 1 tab =RANK.EQ(AB29,(AC29:AC36,AB29:AB36),0) but can't seem to get it to work when I do it over 2 tabs. Any suggestions as to how this can be done? Thank you MM

I would like to find a way to complete the last column using a formula. The results should match year started column. Any suggestions? Book1ABCDEFGHI1Name20142015201620172018Grand TotalYear StartedYear Started using formula2Name 1181820163Name 212152720174Name 329427120165Name 4292920186Name...

Hey guys! I have 2 columns with the following time-format: Column 1: hhmmss (223000) Column 2: hhmmss (234000) Now, how can I get the difference between them? It would be 50min (5000). Do you have any suggestions? best regards!

This line of code is not running: .Attachments.Add Range("I" & i).Value within this code: Sub CreateMail() Dim objOutlook As Object Dim objMail As Object Dim i As Integer Const olMailItem As Long = 0 Dim strbody As String For i...

Hello, I have two if/and statements that need to be combined in the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks. =IF(AND(R19<g19,l17="hourly"),(g19 2080),(g19="" 26))...

Hello - I have a range of numbers in column N(N2:N11485) and I want to highlight these numbers if they match exactly from numbers in column P (P2:P215). Any suggestions?

I am trying to match the Item Number in the BOM sheet and fill in the Description and Price from the Item Master sheet. I need to keep the Item Number columns formtted as Text (I think) because we have many part numbers that begin with 0. I tried google and a few Excel forums but I haven't...

If I want the contents of cell B3 to be put into cell A1, I type in cell A1; =B3 However it isn't doing that. I end up with =B3 typed in cell A1. Any suggestions. Thanx B

I am trying to write a statement with multiple IF's and am coming up short and getting #VALUE response. Here is my current statement, =IF(F140="Y","","NA")*OR(IF(F140="N","Y","NA")) I am assuming that I have something conflicting but am not sure what. Any suggestions?

Hi all I'm creating a Spreadsheet for my schools Sports Day. It's quite a simple document, but am trying to automate some of the functions a little, to help my PE department, make the day a little easier. Problem is I'm stuck on one section, and was hoping for some advice and suggestions...

I have 'inherited' a spreadsheet that has a vlookup in a table that refers to a table in another file. It won't work. Any suggestions?.. I have tried making sure the files are both in the same e-folder on my c drive. I am lost for ideas. I am new to working in tables. would appreciate any...

Dear community, I've been struggling for two weeks now and i can't figure it out. countless attempts of trying brought me here so I hope some of you experts are able, and willingly to help me out. This is what I'm looking for: Whenever the IP addres is changes, i need the webquery output...

Hi I can't get this to work into 1 cell. Here are the 3 parts. MAX(A572:A591)-MIN(A572:A591) (A572)-MAX(A572:A591) then I want to divide both like this (A572)-MAX(A572:A591)/MAX(A572:A591)-MIN(A572:A591) What am I missing, any suggestions? Thx!

Hello, My name is Anya and I work for a charity in south east England. Two colleagues and I are interested in receiving training in Excel, but we haven't had any luck with finding anyone locally who can deliver training in the areas we're looking for: Very, very basic introduction to VBA...

I'm trying to write a formula to solve for X in the image below. I want to know how many 5-star reveiws a client would need to get to an average of 4.5 stars if they already have 6 reviews averaging 4 stars. Any suggestions? It's driving me crazy because I was never too good at algebra.

Every now and then I get what I believe to be a Chinese date. Any suggestions on how to convert this? 2017年11月22日 10:37 I need to keep the time.

Can anyone suggest a way I can do this? I get up to about 120 criteria before excel tells me that the formula is too big. Any suggestions of methods I could use to expand it to 900 (I know this sounds excessive)? Kind Regards.

=IF(OR(A4="WL"),("0"),0) + IF(OR(A4="BL",A4="DL",A4="LL",A4="LGL",A4="NL",A4="MDL",A4="RL",A4="WGL",A4="XL", A4="A",A4="B",A4="CB",A4="D",A4="K",A4="V",A4="X", A4="H",A4="L",A4="LG",A4="M",A4="MD", A4="N",A4="Q",A4="R",A4="T",A4="W",A4="WG",A4="Y"),(A7*B7),0) In the above statement, only BL...