help excel formulas

Hi there, can someone help me with the formulas I need under the columns Automated Deadline Alert and Progress Tracking as shown below in my Excel table? Thanks a million! Nineta

UGH. OK, I would love to be able to count the number of times a name is displayed in a particular date range. The names are listed in column B, all of the specific dates are in column H and the date range is AM1:AN26 (AM1 is 1/1/2018 and AN26 is 12/31/2019). I will appreciate any help!!!

I have a list of names (first and last) and I'd like to separate them into 2 columns. Wait, I know how to do that, I wouldn't waste the time of this forum for something that I can Google. The issue is that the column of names is a formula from another company that I have no access to. How would...

Dear All, Need help with a excel formula to compare various cells in a row and give result if it is common data in multiple cells Condition: - if the cells have a common alphanumeric in a row, at least two or above, then print it as result else "No Result" - different alphanumeric can be...

I have a LARGE nested formula. it works great, except I need it to be bigger. =IF(AA4=AD16,AB4,IF(AA5=AD16,AB5,IF(AA6=AD16,AB6,IF(AA7=AD16,AB7,IF(AA8=AD16,AB8,IF(AA9=AD16,AB9,IF(AA10=AD16,AB10,IF(AA11=AD16,AB11,IF(AA12=AD16,AB12,0))))))))))))) I need it to be up to 99. Is there a way...

Hi there, I am running a find and search function on a column of data on a simple Macro I have created. However I seemed to be getting error 91 when it is encountering data that it cannot find. My current code is: Range("I:I").Select Columns("I:I").Select Selection.Find(What:="1"...

I need a formula that does substitute ALL "" with "" (including the > character) <*span style..** .><*div style=...* *> <*p style..** .> <**div* *> <*/div* > (I added asteriks and spaces otherwise the tags cannot appear :P Find and replace works for the last 2 but not the others at what...

I am trying to use an IF statement to place this or that based on the criteria. For the criteria i am using a MATCH statement to see if a cell matches a individual cell amongst a range. The issue i have is that when the criteria is false it does not use the false function of the IF statement...

I am looking to count the number of times the event took place in January (1) or December (12). I custom displayed the month to just 'mm' and used the formula =countif('Driver Data'!AO:AO,"01") for January or =countif('Driver Data'!AO:AO,"12") for December Any ideas?

HeyI've tried to make a formula but can't get it to happend. I use a formula to count words/names and it works fine:=SUM(COUNTIFS(C63:C72,{"*Mike*","*Peter*","*Jane*","*Even*","*Jack*"}))But my problem is that beside counting the words then I also neet to have the types beside.Eks; cell A1...

I track injuries for my company, and I need to track which type of injuries have occurred in the last 90, 30, and 7 days. for example Column G: Body part affected by injury Column B: Date of injury In Column G I need to know how many times the body part "Arm" occurs within the last 90 days...

Good Morning All, My company is working on upgrading their system for tracking their change orders. We have it currently being tracked on paper and then input into a spreadsheet. We need all the data that goes into the tabs RS, DW, and GM TO automatically input into the Sheet1 spreadsheet...

I'm having a hard time moving data from one sheet to another. I am not sure I fully understand how to use something like "LastRow = Sheets(“Sheet1”).Range(“A” & Rows.Count).End(xlUp).Row." in the correct way Trying to Accomplish: Take data from sheet3, Row Q3:AG3 Copying it Go to sheet1 and...

Hello, I am creating a template that starts with a time series of daily values for the past year (the specific dates will depend on what day I am updating it for). I need to be able to manipulate monthly data from the time series. I am running into issues because there are gaps in the data...

Hi guys, I'm doing a spreadsheet, and basically I need to find a formula that filters data into three sections 3 bands exist: $0 - $20,000 $20,001 - $40,000 $40,000 + For instance the first $20,000 made goes into the first band the next $20,00 goes into the second band and anything more...

Hello, I am using excel 2003 and have the below sample data (from a main excel sheet with 1000's of rows). <colgroup><col span="4"><col><col></colgroup><tbody> A B C D E F ID Owner Region Action Date Timestamp 1001 Shawn APR Closed 12/01/2015 12:52:06am 1001 Shawn APR opened...

We are trying to finish up a project and submit it, but none of us are very proficient at Excel. Well, actually -- we were proficient enough to set up a survey, using formulas, which enables us to tally the results of the survey based on responses. After getting it all set up, we were asked to...