formul

Hi All I am hoping that someone can help. I have been reading the post (Calculate only working hours between two dates excluding weekends) as it was on the right lines for what I needed but I couldn't find the specifics to help me. I have a similar problem with the exception that I work in a...

Hi all, I am trying to create a macro that adds a new row to the bottom of a table and keeps the conditional formatting and functions of the row above it. My knowledge of these types of macros is VERY limited so please be patient when asking questions. I currently have the following macro but...

Hi All Excel Guru's, My first post here so please accept my apologies if I am out of line. Question: (Worksheet attached) I have a workbook with two separate Tabs Tab 1 - Floor Plan: Master Warehouse Map with Locations Tab 2 - Damages : List of Damages in the warehouse I have identified...

Hi guys, I have a spreadsheet exported from from Access, where I have a "False" or "True" cell values which relate to a Country name (If Destination is Costa Rica it's "True"). Now I'm trying to create a formula which would work, if Value is "True" in a range of cells (C4:AG4), then give a Name...

Hi all - I am having some problems with a formula. I am trying to find a formula which picks out the relevant I.D's in the first column and produces how many hours in total it's been worked on if it's with a certain team. The ID will appear several times in column a and will have hours for...

I have a 5000 line table I am filtering by a few columns, and I'd like to calculate an exponential trendline value. =INDEX(LINEST(LN(R1059:R1167),W1059:W1167),1) But I actually don't want all the values from R1059 to R1167 - I want to select only the displayed values (R1059, R1068, R1077...