bill

<tbody> Target GM% 25% Hourly Cost 4.03375 Hourly Pay Rate $80.00 Hourly Bill Rate $100.00 Hourly GM $15.96625 Pay needed for Target GM $70.96625 Bill needed for Target GM GM% 15.96625% Amount off Target GM% -9.03375% </tbody> 1 2 3 4 5=B4-B3-B2 6=B3+(B4*B9) 7 8=B5/B4...

Hello, I need help creating two different formulas: 1) First, I need a formula that calculates the values shown in column D below (i.e., "SUM_SPEAKING_TO_SAME_RECIPIENT") which is the sum of the previous exact same speaker-recipient pairings. So in row 2, the value is 0 because John had not...

Hi All This is my first post as i have joined this fantastic Forum. I am looking for anyone to help me with a problem. I want to run a VBA Macro that will basically search a columns of names and check that each name has letters A(a) to Z(z) and possibly numbers aswell. So Bill Smith is...

I am using Excel 2016 Power Query & Power Pivot. I am going to do my best to explain this but I do not know if I can. I get a massive bill from a vendor each month that has about 350 different account numbers on it. The bill tells me our usage and our charge. It comes in a .txt file I use...

Hi, I am maintaining a monthly utility schedule with column D5 to show the last date to pay bill, column E5 for the amount (which is linked from a particular utility account), and column F5 for messages to popup on at regular intervals according to the approach of maturity date. But...

Hi, I was wondering if someone can help me please. I have a long list of equipment that requires calibrations on different cycles. Some weekly, monthly, semi-annual, and annual. I request some sort of way to automate the process as far as showing what is due. I would like to attach file...

Hey, I am using Excel Invoice and for every new bill i copy the template and rename sheet as bill number say 001 , 002 , 003 and so on , i am wondering if i can insert a button so that i copy current sheet to new sheet in same workbook and have a consecutive series as sheet name (001 , 002 and...

I am hoping someone can help! I have a formula that in some cases is returning a #div/0! error. in it's simplest form in know how to enter the formula to make that a 0. So if my formula were nextbillamount/nextbilldays I would enter if(n(nextbilldays),nextbillamount/nextbildays,0) and I get...

I've tried searching for this specific problem on here and online, with no joy. I have a bunch of projects laid out and pivoted in line with the below pivot table, showing me Hours Spent and Billable Hours for each day and then in total for the week. I would like to calculate a simple...

Hi I want to extract the Text after PO mentioned in below text Note: All PO number are 14 Digit Alphanumaric <tbody> 1 BEING BILL NO JG/18-19/251 AGAINST HERO'S PO NO-CHN:18-19:1517, PO DATE-6-8-2018,ACTIVITY TOWARDS -LOAN MELA (DOWN PAYMENT RS./-1) BARNALA, DURATION-22/06/2018 TO...

Hello, I am trying to collect data from different sheets into a table. I’dlike the table to auto-fill based on the date of the day, and matching the name. The formula shouldn’t count entries, but rather report or copy the number entered in the cell for that person on that date. Example...

Hi there, (all fictitious) Suppose that I have a worksheet with names, date and prizes won at those dates, as they appear in the worksheet. I need a VBA code that concatenate these data in a single row per person, listing the person name, the dates and the prizes wons on each unique date...

In sheet 1, column A - I have a column listed with some name, suppose Bill Jordan James In sheet 2, column A - I have all the names of sheet 1 column A multiple times. In sheet 2 column B - there are two results "yes" and "No" for each names. Suppose, Bill ------------------yes Jordan...

I have a list of names in column A, a list of their numeric scores in Column B. Then I have a list of names in Column C, some of these names are the same as in Column A, some are different, and a list of their numeric scores in Column D. I'd like to return the average score (the average of the...

I have 2 linked tables and wish to create a pivot table showing employee ID, Name and the person's related Role. The tables are linked on Employee ID but query displays what's shown below: Emp ID Name 123 John 456 Bill 789 Joe Empl ID Role 123 Admin 456...

Hello Everyone, I'm trying to use the following formula: <code> =IF(P31=T31,"No-Affiliate bill code = Emp bill code",IF(P31<>T31,"Yes-See Column Q",IF(ISNA(VLOOKUP(K31,'Company Employee Codes'!$B$2:$B$198,1,FALSE)),"No-Account has the correct Emp bill code",0)))</code> The first two are...

Hello Are there formulas that could be placed in Sheet2-4 to pull in data from sheet1 all at once? This example shows 3 sheets, but in reality I have 50 sets of data in sheet1 and would need 50 separate sheets populated Data Sheet1 - A1:A3 Set1 Set2 Set3 Bob Tom...

Two charts below, chart 1 "First" and chart 2 "update". I want to be able to take A1 in "first" and shorten it for say "TennisBalls, LLC nyc Champion" in A2. Same for A3/A4 with Brick, LLC. I have 1000 invoices I need to shorten by just saying the vendor name rather than the full bill payment...

Hello, Hope all are well here! I've been gone for a bit, but now I'm back & doing things with Excel that I haven't done before. This particular issue can't seem to be found anywhere, so I'm calling on the pros here.. I have a sheet with the first column for date ranges and each cell (going...

Hi All, I'm summing a total value, which I know will always be a negative number. Trying to avoid hidden helper cells if possible The current formula is: =SUMIFS('Advance Bill Rec'!T$3:T$2000,'Advance Bill Rec'!K$3:K$2000,D21,'Advance Bill Rec'!U$3:U$2000,">=" & $I$1,'Advance Bill...