revised

Hello, this has been asked before but my problem is a bit different. I want to get rid of some words in a column using a Macro (or formulae) text revised text Text to remove This is a sentence containing keywords. For Analysis, for general. sentence,keywords,analysis,general is this is a...

<tbody> Original Revised Days Overdue 12/2/19 31/3/19 X 31/12/19 X </tbody> Good morning all, I wonder if you could help me out with a query. I have a table with two dates, an original date and a revised date. I need the formula which looks at the revised date first and...

Hi, Not sure if this will be confusing. I have Salary data in sheet 1. Col A Emp Id and Col B Salaries Id Salary 1 289750 2 290617 3 293696 4 293696 5 294941 6 30135 7 305000 8 305913 9 305913 10 307762 11 310464 12 317089 In sheet 2 I have Revised Salary Amount...

I am trying to make a measure that combines a starting budget and a revised budget to create a final budget. As an example of what I am looking for, some line items have a starting budget (say $200) and no revised budget ($0), so the final budget would be $200. Some line items had a starting...

I am looking to add a textbox with the word REVISED in Red and then for it to print on the report. I cant seem to get it to print in color. Current code I below. ' Format certain data ie file header name and sum of data ActiveSheet.Range("A4:D4").Select With...

Hello, I am trying to sum up a column with some budget-numbers, and if there has been a revised budget, use that cell instead of the original. Basically two colums: A - Budget B - Revised 1 3 2 3 1 4 Is it...

I need help in creating a formula that would VLOOKUP a specific value e.g., Item A, Item B, and Item C and return the max value of Baseline and Revised Start Dates for each Item A,B, and C separately in a different worksheet. The goal is to return the latest date or revised date, or if...

Hi, All! I spent the entire day trying to figure out the best way but got stuck. Hoping you all can point me in the right direction. I have a table with four columns (Original, Revised, Completion, and Status). I want the formula to be in the Status column. Basically, what I'm looking to do...

I have a pivottable that lists multiple fields, and has slicers for users and months (among other things). The fields on the table are: Question 1 Question 2 Question 3 Question 4 Question 5 The pivottable's Value Field setting is for the average for each item presented as a percent. The...