greatly

Hi, Can any one advise me how I look up just the Letters in a code, I have the below code which works fine if I want to look up "ULKY5312" but I just want to lookup the Letters only. =VLOOKUP(B5,Project_Approvers,2,TRUE) Your help would be greatly appreciated. Shazz

Hi, I am creating a dashboard and looking to create a dynamic chart which will display the information from the below table by using the months and have hit a wall! The table I have is a fuller version of the condensed one below. <tbody> J F M A M J J A S O N D SB 1520.23 653.21 4568.21...

I need to combine AND and OR in Excel IF statement and I'm not able to get the formula to return the correct answer. Any help would be greatly appreciated!! Example: If A1 is greater than plus or minus $50,000 AND A2 is greater than plus or minus 10%...

This works perfectly for populating a cell with everything left of the first _. =IFERROR(LEFT(B11,FIND("_",B11)-1),"") I was wondering, is there a way to make it show everything after the last "_"? I've been messing with it but I just can't get it to work. The file names are never the same...

Hi.. I am trying to correct my formula to calculate the 90% of K3:K281, if D3:D281 equals, 1,3,4,and 5. I am using the formula below to get the 90% for each number individually, but can't get it to work for all 4 numbers combined. My formula is: =PERCENTILE((IF(D3:D281="1",K3:K281)),0.9) Any...

I have Column A (two empty rows between data), and I need to get to column B with a formula <tbody> Column A Column B a a a b b b c c c </tbody> I am an excel novice trying to keep up! Any explination along with a solution would be greatly appreciated :)

I would like for a date being taken from a user form to have one year added to the date. For example if you enter 1-9-18 in the text box on the form I would like the date that goes into the data sheet to be 1-9-19. Any help would be greatly appreciated

Hi I am making charts in excell and when I notice a data point in the chart that I want to examine in the data relative to other values not charted. How can I pinpoint it? Hoverring over the chart gives the number of the point in the series and value but my chart data sets are selected from...

I am a complete noob in regards to excel and formulas so any help would be greatly appreciated. I am trying to get a formula to automatically display "Day SHIFT", "SWING SHIFT", or "MID SHIFT depending on the current time. So the time range for "DAY SHIFT" would be 0730 to 1630, "SWING SHIFT"...

Hi All Bit of maths help please. There is a tank of Active Carbon, which when full to 100% holds 57 M3(meters Cubed) (1% of the tank would be 0.57 M3) If the amount used in a day was say 1% which is 0.57 M3, how do i convert this to tonnes? Any help will be greatly received.

Hi All, I need a macro that will set calculations to manual when a sheet is opened and calculate the sheet with the Enter key. Your help is greatly appreciated!

Hi guys, any help would be greatly appreciated: This works: =COUNTIFS(HeadcountFeed!$G$4:$G$600,">="&$B$8,HeadcountFeed!$G$4:$G$600,"<="&$B$9,HeadcountFeed!$F$4:$F$600,$A45) This does not: =COUNTIFS(INDIRECT(B15,TRUE),">="&$B$8,INDIRECT(B15,TRUE),"<="&$B$9,INDIRECT(B15,TRUE),$A45) with B15...

In D2, time was entered as text. It looks like this: I have 0730-1200. I need to convert text to time. In E2, I need 07:30 AM In F2, I need 12:00 PM Any help will be greatly appreciated. DJ

So I have been try for the past hour or so to get this formula working but this is the best I could come up with =COUNTIFS('PASTE HERE'!$D$2:$D$1000000,A11,'PASTE HERE'!$J$2:$J$1000000,"Outbound",'PASTE HERE'!$I$2:$I$1000000,">0") is there any way to convert this to a sum-product or something so...

Please see file that I uploaded in OneDrive I have explained the help I need in the file. I would greatly appreciate any help i get. I tried a lot. but it seems quite challenging. Thank you!

I have searched but I have not found a solution that has worked. I continually get a "runtime error '1004' method 'saveas' of object '_workbook' failed" in my .xltm file's code while it is attempting to save it as a .xlsm. I have tried different variations and methods but nothing seems to...

I have a problem getting this formula to work.. It only works when there are numbers in C3 and J3, otherwise I get a FALSE in the cell.. The boards help is greatly appreciated.. Thank You...

Good day everyone Can someone please help me with the following... <tbody> A B 1 <tbody> http://www.xyz.co.za/ProdImg/AA13NDfl1uuL2c.jpg </tbody> <tbody> http://www.africaestore.com/esquire/AA13NDfl1uuL2c.jpg </tbody> 2 <tbody>...

I'm interested in a macro that removes an entire row if the sentence in cell "O' doesn't end in a period. Also if the macro could ignore the first row which is headings. Thanks for your help, greatly appreciated.

Hi, Im looking to auto sort a column in sheet3, when data i, column J of sheet1 is changed, i currently have the bellow but it doesnt work? any help is greatly appreciated Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not...