rev

Hello - I have several cell that contain dates in text format. I'm trying to extract the dates from those cells & return values as a date format, preferably (Jun-19) format. Below is an example: I'm using =MID(A1,FIND("/",A1)-2,5) to extract -6/18, and then =SUBSTITUTE(B1,"-","") to get rid of...

Hi All, I am trying to create a formula to have data populated from a drop down menu but I am unable to get it to work correctly. <colgroup><col><col><col><col span="2"></colgroup><tbody> Depending on which department you select, the data should automatically populate, but I am not sure...

I am using Power Query in Excel for the first time. Got query to work fine but have too much unneeded data. Query combines 1000+ files. Each file has ~150 rows of data. Files are named using serial number (SN) and Revision letter for each file. There are multiple files of different revision...

I have the formula below I was needing a little help with. I have another cell C2 that I would like for it to look at also. If there is something in it then have formula look at it before F3. The formula below is copied down about 30 rows. C2 is by itself. =IF(ISBLANK(E3),"",F3&" Rev "&E3)

Hello All, I have this code very close to what I need it to do but I think I need to add a counter of some sort. I'll try to explain this AS BEST AS POSSIBLE. I need this code to count how many times there is an occurrence of an Alphanumeric value in Column C and then simply increment the...

Hello all, I have a code below that copies the contents in columns A, B and C to the next blank row. I also need this code to Duplicate/Rename the contents in Cell C with, preferably REV 1 after it. Basically here is the format the users will be putting in Column C: LEVEL 1/ AREA A/ RM 125 I...

Hello All; I have a log that users will be adjusting data based off statuses of Drawings. Starting at A11, B11 & C11: Column A is DRW NO., Column B is DRW Description and Column C is Location/Rm. Over in Column L is the status column where the user will select from drop down list. I have this...

<tbody> Account CC Acc-CC Descr Jan Feb Mar Apr 301000 000 301000 000 Alt Rev 0 0 0 0 301000 100 301000 100 Alt Rev 500 500 200 400 301001 000 301001 000 Revenue 5000 8000 10000 6000 301001 100 301001 100 Revenue 0 2000 5000 8000 301001 200...

Hello, I have a code where I'm getting an error on my array ... the code works perfect when array is like this For Each Ws In Sheets(Array("RLN-Net Realization", "RLN-Red Rev", "RLN-COGS")) But when I add and extra sheet For Each Ws In Sheets(Array("RLN-Net Realization", "RLN-Red...

I have a simple =SUM(A1:G1) formula here but it's not working. It's like it's missing column data and giving incorrect totals. Each result (A:G) is populated by an IF formula. Any thoughts why Sum would not be working properly? Auto Calculation is on, which is the only thing i can think of...

Hi, I am looking to hide an array of worksheets as shown below; Worksheets(Array("Data Log", "Rev. History", "Visual Set Point")).Visible = False This works great to hide the worksheets, however what I am really looking to do is, very hide the worksheets, something like this...

As shown in below screen shot I have three revisions. Some sheets has all three revisions but has either one or two only. In the last column (TERMED AS FINAL in BELOW ) i need to show the latest revision. <tbody> SHEET REV. 01 REV. 02 REV. 03 FINAL P029-DDD-STR-0001 A B P029-DDD-STR-0002...

Hi all, I have the following formula in column “U”, '=IF(I37="","",IF(I37="BIL",LEFT($U$8,4)&" JIB",IF(I37="NON",LEFT($U$8,4)&" REV"))) I want to update it so that instead of, LEFT($U$8,4)&" REV"))) it should read the date from column, “M”, and take the previous month, so if the date is...

Hello, I have a workbook with data formatted as follows: <tbody> A B C D E... BZ 1 Location Item DType Week1 Week2... 2 100 ABC qty 3 5 3 100 ABC rev 30 50 4 100 DEF qty 0 3 5 100 DEF rev 0 90 6 101 ABC qty -1 5 7...1MM+ 101 ABC rev -8.5 42.5 </tbody> Where the weekly...

I have a spreadsheet with multiple part numbers and in many cases, duplicate part numbers. There are 10,000 rows! <tbody> F G AO 1 000746-A-1 REV H <tbody> 000746-A-1 REV H OP-10 </tbody> <tbody> SHEAR 1st PC FOR INSPECTION Use 14 Gage (.075") 304SS, Shear strip to 3.25"Wide Move to...

Hi all, I have a chart showing revenue and costs by month. There are some months that rev is greater than cost and other months when the opposite is true. I wish to shade in between the lines e.g. when cost is greater than rev red, whilst when revenue is greater than cost say green. I have...

Hi, some of the team are updating data that is in the format below (Table A): Table A Country Region Metric 01/02/2018 02/02/2018 03/02/2018 04/02/2018 05/02/2018 06/02/2018 07/02/2018 UK Region1 Sales 1 2 3 4 5 6 7 UK Region2 Sales 6 6 6 6 6 6 6 US Region1 Sales 11 12 13 14 15 16 17...

I have a list of Revisions and I basically want to make sure that any revision that is a number (NOT a letter) is custom formatted "00" so it shows as a Rev. 01, 02, 03, etc and NOT just Rev. 1, 2, 3. I want this to be via VBA as I have an Excel Add In I am creating for other users. There are...

Hey Everyone! I could use some assistance in getting past a wall I've come upon. I'm needing to calculate the MAX value of a column after scrubbing the top 10% & bottom 10% from a separate staffed column using a Percentile formula. These two Formulas are pulling the Top & Bottom Staffed...

Not sure if this can be done but it would be very useful to me if it would work. What I’m wanting to do when I click a button: 1. On sheet “Job Notes” Cell F24 - Contains a text value “INTERNAL DESIGN PRESSURE 1500 PSIG @ -20 °F AND 250 °F “ 2. On sheet “DO NOT CHANGE” Cell C5...