std

I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a...

I am trying to find the standard deviation for data presented in different ranges and I am currently using the following equation: =+STDEV.S(IF((e7a1!A12:A1010>=Primary!K$5)*e7a1!A12:A1010<=Primary!K$6);INDEX(Table1;0;MATCH($D19;Table1[#Headers];0));)) The reason for the formatting is that its...

I need to answer 2 questions from the table below to return a query from below the temperature range tables I need to ask CSN #, and then ask the operating temperature, returning a query from the stress table below. example: CSN 6, with an operating temperature of 550, returning the answer...

Hi all, I need to create "What if" table to "Sales" column (example below) of the company, the std. is 20% in gap of 5% Sales <tbody> $4M $30.9M $80.36M $254.64M $728.2M $17M $88.27M </tbody> How can I create this kind of table? Many thanks, :) Israelinas

Hey guys always such great help!!!! Problem statement: need a formula that searches for like 'A' in column A and creates STD for all 'A'. Data/Example: Column 'A' Column 'B' A .05 D .005 Z 1.5 A...

I am working on extracting some information from an existing spreadsheet and copying the information to another sheet based on search. In column named Welder I want to extract that rows information for each individual welder initial and create a different workbook for each one. What would be...

Trying to build a sheet to assist in calculating available working hours vs required hours for a job. Please help with a formula that will calculate Columns D and E based on the logic below: Sheet is setup like this: <tbody> Date Day Status STD HRS OT HRS TOTAL HRS 2-Jul WEEKDAY...

In the first sheet, where the data is entered, I want to populate the second sheet. Column "H" in the first sheet there is different data entered, and I want to find specifically STD-210, and then populate the associated sample number in the first sheet, which is in the "I" column, into the...

I have table like below. Is it possible to write something up to show on a separate sheet or on a popup the parameters( age etc) and give me an option to choose wether I want an average or std Deviation of the data set for each parameter. Example table: <tbody> Parameter SET1 SET2 SET3 Age...