i.e

anyone able to help me with the above. I have a column which contains numbers with + or - i.e. 4+ or -4. I want to convert these numbers i.e. 4+ would equal 4.33 and -4 would equal 3.67 - any ideas on how I can achieve this? If the cell contains a whole number i.e. 4 then the formula is to...

Hello, I would like to see what function you all would suggest to use for looking up a moving range of data based on date range of i.e rolling 30 days? Would it be an index match or vlookup etc.? For example I have a list of data in column cells that will be unique for that month but would...

1 BOX = 600 PCS 1 BOX = 15 PKT 1 PKT = 4 STRIP 1 PKT = 40 PCS i.e. A=290 PCS B=100 PCS C=350 PCS D=132 PCS E= 460 PCS F= (A+B+C+D+E) = 1332 PCS NOW I WANT CONVORT THIS QTY IN BOX/PKT/STRIP/PCS i.e G= BOX H= PKT I= STRIP J= PCS I WISH TO GET RESULT LIKE BELLOW G=2BOX H=3 PKT I=1 STRIP...

When using the advance filter, it works fine, however, if I have words have similart starting letters (i.e. MS, MSFT or C, CVX, CVS...), it filters everthing. I would like to show only show data with the whole letters (i.e. if I want to see MS, show only MS, not MS, MSFT or C not CVS and CVX...

I have a table setup that in column A has the Quarter of the year (i.e. 1st Qtr, 2nd Qtr), and in column C it has the month, and in column D it has the week (week 1, week 2). I have the weeks broken down based on date on another sheet, but what is the easiest way to get the weeks aligned by...

Greetings, I have not been able to find an answer using search techniques and hoping some one may have a solution for me ... I have a worksheet with a couple of columns that have formulas. The formulas' result is to conclude with either a specific cell's value (it will be numeric) or results...

Hi all, I have a number of workbooks (i.e. workbook 1,2,3) that are summarised in one workbook (i.e. workbook 4). Workbooks 1,2,3 will need to be updated throughout time and they will also need to have other copies for scenario analysis. My issue is with version control. When I update...

<thead>#DAE7F5[/URL] "] A B C D E F G </thead><tbody> 1 Output Migration Date Renewal Date 5 month prior date (migration dt column B -(substract) 5 months prior) Risk Flag Final Comment 2 Yes Sunday, March 1, 2020 Friday, July 5, 2019 Tuesday, October 1, 2019 Low PEP Ready to Migrate 3 No...

Hi, I posted an array formula question on the 2nd of Nov at 09:17, which was answered, but frustrating only raised more questions. Having done a bit more reading-up on array formulae, I thought I would try and answer them myself. The problem I have is with the following formula...

Hi all thanks in advance for answering. Is there a formula that will give a sequential code to a range of alphas and the sequence resets to 0001 when the alpha changes? I.E a customer code file would generate the following: ABCD0001 ABCD0002 ABCD0003 DEFG0001 HIJK0001 HIJK0002 HIJK0003...

Hello, I am trying to point excel workbook 1 to a worksheet in a linked workbook 2. basically the worksheet name changes and I need to update all the formulas that point to that worksheet on a weekly basis. Is there a way to automate this? i.e. in workbook 1, I have the formula...

Hello :) I have been reading this Similar Thread but cannot work out how to alter the solution to solve my problem. I have a Worksheet which runs columns A through BC with approximately 2,000 rows, here is a shortened version with just 2 rows: Workbook For each existing row: for each...

Book1ABCDEF1Risk RaitingCountryRenewal dateOutputRelevant countries2LowCanada;Germany;UKFriday, October 26, 2018YesUK3HighCanada;Luxembourg;UKSaturday, October 27, 2018NoUnited Kingdom4MediumAU;EMEA;NZFriday, October 19, 2018NoEMEA5LowLuxembourgFriday, October 27, 2017YesBE6MediumAusSaturday...

Are there any sale dashboard templates people use that they could share? Particularly interested in Speedometer Radial type graphs. I.e green is good, yellow ok and red is bad.

Came across an interesting situation. when i have a network drive mapped by name (I.e. \\servername\share) i can open a spreadsheet with no problems. however, if the network drive is mapped by IP address (I.e. \\10.1.1.1.\share) it tells me the file is corrupt. Very odd i must say. This is...

Hoping you could help me with an IF statement with range of numbers. For example, per the table below, if my value is between the low range (i.e. 137) and high range (i.e. 227), i want Excel to return "Level2", and so on <tbody> low high level # <colgroup><col...

I want to fill cells in a column with data (PRI134/18) Can anyone advise how I can do this as when dragging the cells down it changes the last two digits to 19, I want the number sequence before the / to change to i.e PRI135/18, PRI136/18 and so on. Your help is appreciated. Shazz x

Ok ... so I have a spreadsheet that is tracking a renovation project. At the top, running horizontally, I have the dates of when different aspects of the project starts. Below that I have several rows of itemized projects and conditional format the cells, so that when I put an "x" under any...

I work at a facility that doesn't allow macros to be enabled but I have lots of data to pull in and I want to create specs for it like you would in Access so it doesn't take so long to clean. Is it also possible to fill in the last column with the name in the text file after the underscore i.e...

I am trying to do a find replace on formulas that include * for multiplication. A lot of cells that have *12, *11, *10, etc. and I want to replace all of these to be *1. When I try to do a find replace of '*12' it replaces everything prior to the *12 since the * is flagged as the wildcard...