claim

I have a spreadsheet with multiple claim lines per day for various events taking place per customer. I am looking for either a Power Query or Power Pivot solution to show all claim lines for only dates where a particular event took place on one of the claim lines. For example, if customer ID...

A B 4805 50.00 4805 45.00 4805 0.00 4900 0.00 4900 0.00 5010 48.00 5010 62.00 5010 58.00 In the above table column A has claim numbers, and column B amounts paid. A claim can be either partially paid (#4805); not paid at...

Hi Boys and Girls, I need a little help. I have a set of data with the following columns; Job Name, Claim Number, Value Job 1, claim 1, £300 Job 1, claim 2, £450 Job 2, claim 1, £300 Job 3, claim 1, £600 I am trying to use VLOOKUP, somewhat erroneously, to pull across all rows pertaining to...

I tried the formulas here, but they are all returning #VALUE . https://www.mrexcel.com/forum/excel-questions/503651-counting-number-times-specific-month-appears-range.html Please note that I am referencing a separate workbook ('[2018 Claim Status Sheet.xlsx]Active Claims') which has the dates...

In column "A" I have a number called LOA. In column "AS" I have claim numbers. In column "AN" I have DOS From. "AO" is DOS to. I need two formulas. Formula 1: "Is there more than one claim number per LOA? So, I need it to look at the LOA number, see if there are duplicates (which...

I have a worksheet where I have a column of Claim Numbers (column AS), and a column of LOAs (column A), and I need a formula that looks for "is there more than one claim number per LOA?" I have a few other similar formulas, but can create them once I get the help I need creating this first one...

Hi Folks Hope you can help me with my calculation please? Much appreciated for any assistance you can offer me on this. <tbody> Enter Mileage Claim Here 1500 KM Four Criteria Mileage Calculation Band €/KM KM Range Distance KM € Text 1 €0.4479 0 to 1500...

I have a large amount of data. I have a scenario where, in column BP (starting at row 6), I need to populate a formula that will look at the claim number in column AS. There will be multiple lines with the same claim number in AS. I need it to compare all the claim numbers that are the same, and...

I’m trying to alter the following formula =IF(F20*I20=0,"",F20*I20) I want to add to the formula that if I20 contains the text "claim" then the value of the cell will equal 0

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I have 3 populated tables for Types of insurance claim down the y axis (public liability, flood...

Good afternoon, My name is Nadine and I am looking for help on trying to solve get this formula to work or if you have a better way to help me get what I need, that would be appreciated! I have two worksheets, one worksheet has a column with claim numbers in it and one is a blank column that...

=sumproduct not workingGood afternoon, I have two spreadsheets located in two different workbooks with several columns, one of them being a Claim Number column with values that look like this: ER570W25600, none of the claim numbers are the same and a net savings column (they are not right next...

I have multiple cells around 200 having each cell text like below. I need only information starting with 1. up till 1. ends (Example: 1.A mounti... ...in disalignment. ) Following description includes: 1.A mounting system for supporting on a dental endosseous implant having a longitudinal...

Hi, I am trying to redesign an expenses form for work and need to put certain limits on meal types. You can claim for breakfast, lunch and dinner and the maximum amount you can claim is £5, £5 and £18 respectively. The meal options are selected from a drop down list (there are other items in...

Hi guys, I have this book I'm working on called AZ Claim Database. Randomly (does not occur every save) it will tell me this: Sooo I press continue and rename it "AZ Claim Database 2"... This isn't making much sense to me. Does anyone have any clue as to why it would do this? It's...

Hello Guys, Hope you are doing well today, I appreciate your quick response and help on the above concept, however i have few things which i want to bring to your notice and require your assistance in getting one single function for the previous scenario provided in addition to the other two...

Hello all, I have a project to work on where i am unaware and failed to get output i am looking for. Can anyone look into the below description with condtions and help me with a code which would fulfil this. For example: B7 = Receipt amount E7 = Claim amount. Claim amount= If Receipt...

I work in the banking industry and I am trying to save some time. I work fraud debit card claims and when we deny a claim, we have to use a lengthy note to leave on the claim. As of right now I have one that I can copy and paste but I still have to take a min or so editing it. So I created an...

Hi guys I need to write a formula that will automatically reduce the retention claim amount. So at the moment retention is kept at 10% each claim until 5% of the Main Contract Price is reached. For example: The Main contract price $2,231,435.00 5% of this is $111,571.75 (this is the...

I'm trying to build a PivotTable that will show us how many total units each of our clients has in their authorizations, how many units have been used, and how many are left. Every two weeks our payer sends us an "Auth Dump" that includes the client ID, authorization ID #, service name, start...