paid

  1. D

    Fuzzy Lookup Meets Find and Replace

    So first things first, my title might be inaccurate but I'm not sure of the terminology. I have a long list within a single column of various length text. Most of these text strings will contain, in part, 1 of about 30 known phrases. In the column next to the original text I'd like to place the...
  2. G

    Help with VBA to return values to given cells

    Hi everyone, I have a worksheet called "Fees Paid" that holds members names and other values, In cells "A through to J" Then i use another worksheet called "MembersReport", on the worksheet i use Vlookup formulas to return matching values from "Fees Paid" worksheet to certain cells in the...
  3. pcorpz

    help adding an AND to my if or statement!

    =IF(OR([@[Item Group]]="Labor",[@[Item Group]]="Labor - 3rd Party",[@[Item Group]]="Sub Contracts", [@[Item Group]]="Cloud Services"),[@[Total Sales]]*0.8,[@[Total Cost]]) I want to add another condition to only the "Labor" item group... and the condition is [@[Item No]] does not equal "Paid by...
  4. D

    Formula question to grey out a cell and not count it

    Okay, so question i have is this, i have a budget sheet that has the monthly bills in their own cell and my net on top and the leftover on the bottom. so basically the leftover formula is the sum of the positive currency minus the bills. so what i am trying to do is once the payment is taken...
  5. D

    Excel Question in regards to formulas

    Okay, so question i have is this, i have a budget sheet that has the monthly bills in their own cell and my net on top and the leftover on the bottom. so basically the leftover formula is the sum of the positive currency minus the bills. so what i am trying to do is once the payment is...
  6. shyam

    who has to pay or receive from who?

    Four people travelled to a place. their total expenses was Rs.2850. Divided equally would be Rs.712.50 A is charged 712.50 but paid Rs.1940 B is charged 712.50 but paid NIL C is charged 712.50 but paid 820 D is charged 712.50 but paid 90. Now A has to receive 1227.50 and C has to receive...
  7. P

    Totally confused in Leave days & Earned days

    Hi, :confused: Confused have put a lot time on below but couldn't find Solved it sadly ;( I have a Senior hopefully might we can Solve below situation with formula. Ever employee has number of Paid laves in his account. But those paid leaves can't be availed all at once. Only allowed or can...
  8. S

    Find ID number

    Hi Guys, Could anyone suggest me how to find cells containing "ID 1234" or "ID12345" or " ID 123456"? Number could be 4 to 6 digits number. I need to identify from bank statements those transactions, where ID number is given in the description field. There could be the case when description is...
  9. C

    Interest calculated daily, paid monthly

    I have a savings account where interest is calculated daily and paid on the 3rd of each month. Most months the account is not touched but sometimes I might pay an amount in or take some out. Have created a spreadsheet with columns for amounts in/out, daily balance, number of days between...
  10. danhendo888

    Formula to show whether invoice is paid AND/OR approved

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style="...
  11. R

    Tracking accruals multiple tabs

    Hi guys, Trying to track accruals from different month's tabs in my spreadsheet to determine who has made over 99.99 and needs to be paid. In my spreadsheet, please refer to the June tab. Column N, O and P are the ones I am interested in. I am particularly keen to basically determine whether...
  12. Expiry

    Microsoft Office - non subscription

    I was having problems with my mac and had to basically wipe it clean and start again. I sensibly saved all my files and docs etc. I stupidly forgot all about my MS Office suite. I really don't want to subscribe with a monthly fee. I really hate the online free versions. I can't find my key...
  13. P

    Determine if date is within range

    I have beat my head against the wall with this one. I really hope someone can help here. To Completely summarize what I am trying to do.... { If it is Peter's pay-week, N4 equals Y1 If it is Casey's pay-week, N4 equals Y1 + Y2 } -----------------------------------------------------------------...
  14. G

    Matching cells to give a result for invoices paid or not paid

    Hi there, I have two lists on one spreadsheet with the invoice number being common to both lists. The list on the left is from a supplier and the one on the right is my list. The list is about 2,000 lines and what the supplier wants to find out is if I have received their invoice and is it paid...
  15. C

    Auto Calculate Amount Remaining

    <tbody> A B C D E F G H 1 Debt Payment Due Jun Jul Aug Sep Oct 2 Loan $75 1st Y 3 CC1 $25 4th Y 4 CC2 $25 10th Y 5 CC3 $30 15th 6 Internet $75 20th 7 Cell $100 21st Y 8 Ins $100 24th 9 Car $350...
  16. S

    How to remove dots

    Hi all I have list of details have dots at the end I want formula to remove all please help me in this. <colgroup><col width="153" style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595;"> <tbody> Match Type . . . . . . Address Number ( # ) . Mailing Name . . . ...
  17. E

    excel formula to distribute value

    amount received 125000 amount receivable amount paid 100000 30000 30000 30000 50000 100000 i need a formula that when i put amount in a cell amount received it distributes the value in column of amount paid matching with values in amount receivable like in this example in 1 row...
  18. S

    Counting a sign up list & if paid

    Hi Everybody! I have a list of names for an event people need to sign up & pay for. In an Ideal world, I would like excel to count if somebody is on the list, and also if they have paid. Right now I'm sorting this by text color and manually counting. I'm not sure if I need to create Macro...
  19. H

    No Remittance Advice - assistance with allocation

    Good Afternoon. Working in a finance department, we quite often get issuesthat payments are received, but we have no idea what invoice numbers have beenpaid in that particular payment. This is because the client has not provided aremittance advice (list of invoices they have paid). I am...
  20. Shazz

    Adapt Formula to include Becoming Due & Paid

    Good Morning all, I have the below Formula which is great but I want to add to it to show, upcoming due dates (3 days before due) saying "Becoming Due" and also if a date is in Column Q then the cell that the formula is in (Column M) will say "Paid"...

Some videos you may like

This Week's Hot Topics

Top