bill

  1. J

    Value needed to reach target percentage

    <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...
  2. E

    Need two different formulas to sum previous number of dyadic interactions across large dataset

    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...
  3. Z

    excel vba to check cell are have only letters AND NUMBER

    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...
  4. C

    Counting back until a change occurs

    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...
  5. S

    popup message not deactivated

    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...
  6. L

    Calibrations

    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...
  7. M

    Macros to add new worksheet and change name

    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...
  8. C

    Help with Embedded If statement

    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...
  9. R

    Calculate % variance between 2 total columns in pivot table

    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...
  10. hardeep.kanwar

    Need to Extract Text

    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...
  11. L

    Copying contents of a cell based on a 'match' from two columns

    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...
  12. E

    Macro to concatenate data

    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...
  13. F

    Using vlookup with countif

    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...
  14. D

    Finding an average of two columns with some same, some different identifiers, vlookup? ifavg?

    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...
  15. T

    Power Pivot: 2 small linked tables returning too many results

    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...
  16. D

    Nested if formula not working

    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,'Comcast Employee Codes'!$B$2:$B$198,1,FALSE)),"No-Account has the correct Emp bill code",0)))</code> The first two are...
  17. P

    50 sets of data in sheet1 , need to create 50 new sheets and pull in 1 set of data for each

    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...
  18. E

    How do you pull particular information out of a single word cell in order to shorten it?

    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...
  19. S

    Linking a range of dated cells to specific dollar amounts from another sheet

    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...
  20. D

    Convert negative numbers to positive within an existing formula

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top