excel-formula

Hello All, After searching extensively for a few days, I came across this thread: Calculate only working hours between two dates excluding weekends, and the formula presented by Mr. Barry Houdini, was modified by me to suit my needs. This modified formula itself works when applied into a cell...

I am currently working on an excel workbook that is pulling in a list of roughly 1000 reports going to a bunch of different emails. It is setup as Sheet: "ReportValues" Column A being Report Titles and Columns B-Q having all the different emails that the reports are sent to. I am trying to make...

I have two sheets on the first sheet, Column A have the project name, I have Columns K, L, U where I have dates that change on a weekly basis. On Sheet two I have same thing starting with A27, I have the same project names, however on F27, G27 and H27 where I manually enter the historical...

I am trying to write a formula that will count the number of rows between the first appearance of a specific text within a string, and the last appearance of that same text. For example, if Column A contains the following values... Email sent 12/15/2017. Email sent 12/15/2017. Sold in 2017...

Hi, I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) with four values Sev-1, Sev-2, Sev-3,Sev-4 and J is date Field with heading Lodgeddate. i want to calculate severity count for today, this month...

s a completely green member, I turn to you in the hopes of finding a solution to the following problem. I have a table, where I need to sort data based on a downloaded sheet from a ministry. The data is updated every week, but I need to translate it into monthly values (basically the latest...

I need an excel formula that searches within a range, a cell that contains a word with letter "W" and then multiply the number stored in the cell from the right of it by 2 and display the sum of all this multiplied values in another cell. Example: Range A4:Y4; B4 contains word "Woo" and C4...

I use this formula for copy data into sheet1 from Sheet2 =VLOOKUPINDEX($A1,Sheet2!$A:$B,COLUMN(),FALSE) When i use VLookup formula with small text it works fine but with a large text it doesn't work. Any Solution?

Hi all, Firstly, I know nothing about excel formulas, I’m trying to return numeric values by selecting “cash” or “card” in a drop down box with this text that would return a value from multiple rows or cells with the return value, This is a cash book spreadsheet with July to June tabs, any...

This is my first post on here, so I apologize if I leave out details or do not explain something well enough. I have a range, where values between 1 and 5 are entered manually depending on how well someone scored, and a total row that calculates the averages of the column per section. If there...

I have the following worksheet: A B C D E +-----+-----------+---------+--------+-------------+ 1 |FALSE|Lot ABC123 |Product 1|Used qty|remaining qty| +-----+-----------+---------+--------+-------------+ 2 |TRUE |Lot ABC321 |Product...