formula and functions

I am having trouble trying to get this formula to work. In the workbook I have a scorecard table(sheet 1 & its not a pivot table) that pulls in the information from raw data(sheet 2). I want to return the top 5 contract #'s based on the top five highest priority level and contract owner name...

Hi, I am working with a set of data, which cannot be uploaded unless I convert it to a particular numeric value. I am dealing with more than 20 such data sets spread across different cells. For example, as shown below, you will find some common datasets - AR, AF, Web, PR. Now, every dataset...

Dear sir, Here i want to maintain the attendance from time keeping software, My office time is 10:00 AM to 6:30 PM, and we have 15 min of grace limit, but if somebody comes after 10:15 AM then I need to remark as a half day, Please suggest me which formula will be use.

I am trying to add the round function to an existing formula within my excel file. I want to add it to my if statement currently functioning as a look up reference to a range of data. However, the range is not in chronological order and I would like to do a quick update to the entire population...

i am trying to create a proposal from information that i gathered about a month ago. I would like to input a formula that shows todays date if information changes in cell M23 but doesnt change every time i reopen the document. i am not going to be physically changing the data in cell M23 it will...

<tbody> Date Lead Tech Non Lead Tech Completed 3/11/2016 Y 3/15/2016 N 3/16/2016 N 3/17/2016 Y 3/20/2016 N </tbody> So I want a count of all the “Y” values in the Completed column based off the date range of 3/11/2016-3/18/2016. My formula goes like this...

Hi All, I currently have 2 sheets both containing a single column that is common. What I am trying to achieve is a index and match on this column, effectively creating one master sheet. Sheet 1 <colgroup><col><col></colgroup><tbody> WORKSHEET 01 VALUE W1-A VALUE W1-B W1-A1 W1-B1 W1-A2...

I have input my formula and for the values in the column only 1/2 are correct. this is my formula =(K35-L35)*G35 The value of k35 is $12.60 the value of l35 is $12.12 the value of g35 is 16000 the correct amount is $7680.00 my excel is showing $7753.00 it has done this for several cells in...

So I have a formula I'm trying to build to track my bonus at work. Right now, the formula looks like this: =IF((C4/B4)>=90%, IF(G4<4.99%,500, IF(AND(G4>=5%,G4<=5.99%),450, IF(AND(G4>=6%,G4<=6.99%),300, IF(AND(G4>=7%,G4<=7.99%),250...

Good afternoon, I have a long formula that generates a LOOKUP function from varying sources it is looking for the maximum value in Column I then getting the correlated point in column B, to perform the LOOKUP of the timings in column A, this data is a wave form and I need to find it's initial...

Hi Everybody. Thanks for your time. New guy here. I tried the site's search and found some similar questions with replies, but the solution links are no longer working. Hoping some kind generous Excel wiz might help with a formula for reporting productivity rate with an eye on daily average...

Good Morning I have a large spreadsheet with a series of actions which includes the date the action was added, the date the action was scheduled to occur and the date the action was completed. What I want to do is create a formula that will count the number of instances (rows) where the...

Hi All, I have been asked to explain the following formula: =IF($C22=$C21, "", AVERAGEIF($C:$C,$C22,D:D)) If anyone could break down what this formula is calculating, I would be very grateful. Thanks

Hi To Everyone, I am trying to achieve the following Task.. Assume I have 2 different google spreadsheets. Spreadsheet A having 300 entries & it will update daily basis, having Range of A1:O300. In SpreadSheet B, I have two <gs id="55e0d86b-3755-427b-b8db-ebeda470bba6"...

Hello, I was wondering how I would go about putting together 2 separate formulas for the case below: I have table, within the table I have a column named " Status" and "Date of request". Within the "Status" column, I have two filters: "Waiting on dealer" and "part is locked" I would like...

basically it's a range of cells example e3:e50 and i need one cell to show the current value like I'm at e8 and the value changes at e9 and shows what the value in e9 is does that make sence

Why doesn't this work? =SUMIF(H6,">0")+(Q6,">0")+(Z6,">0")+(AI6,>0")+(AM6,">0"). I am wanting to sum the fields only if these numbers in these fields are positive. I would appreciate any help. They represent Overtime Hours. Thank you.

Hi Im new to Excel Forums so please be gentle with me I need some help I have some research that i have been doing for work and have just been informed by the developers that they need the data in a certain format. For example i have researched the price of a beer like Budweiser from 6...

HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING THS FORMULA N EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA.. I WANT TO COUNT " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN" FOR EXAMPLE: DISTRICT--> JAMSHORO HAD FOLLOWING COUNT BASED ON column MEDIUM SINDHI (...

Hi friends, I need urgent help in creating a formula for a monthly headcount report. I am able to find a formula suitable for me in an old thread. However, for some reasons, it does not exactly fit my case and I would need help on modifying the formula. <tbody> 1 A B C D E F G H I J K L M N O...