jeanie

  1. S

    split costs by overlap range dates

    Hello I have a list of costs to be divided for a list of users. Is it possible to allocate the costs, which the date range concerning, to users on the days of use? NB if in one day more users use the same service / cost, the cost must be divided by the number of users <html><head><title>Excel...
  2. L

    Auto Fill Customer Information Based on ID

    Hi, Is there a good way to auto fill the Template sheet customer information in yellow from the Customers sheet based on the ID entered in cell I6? Thank you Excel WorkbookBCDE6Estimate For7[Contact Name]8[Company Name]9[Street Address]10[City][ST][Zip Code]11[Phone]12[Email]Template Excel...
  3. How_Do_I

    Wp(r)

    What is happening when I try to type WP(R) in to a cell and how do I stop this please? Excel WorkbookA1WPSheet1
  4. L

    Maintenance Log

    Hello, I have received some fantastic help so far and I appreciate the lessons. I am trying to apply copy and pasting rows with code for my new application but no success yet. What I would like to do is copy the checked maintenance row from Sheet1 to the end of the table in Sheet2 then clear...
  5. S

    Date Calculation

    Hi Experts, My data is as below. is the output in Column G possible without helper column C? <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:73px;"><col style="width:73px;"><col style="width:64px;"><col style="width:64px;"><col...
  6. K

    If and Vlookup with Multiple Criteria

    Hi, I have a list of data where the letters starts with the list in the table below in column Category. I need to insert a formula to return as the column "Then". I tried If and LEFT but I am not sure to cater for the long list . Is there a way have a formula for this ? Appreciate all the...
  7. B

    VLookup

    Hi I think I need a VLookup but I don't really know. I wan't to lookup the data column D and match the entry in Cell C5 (pink). The BLUE D21 is the correct match. Then I wan't to put the Min and Max from columns E and F into cells A5 and B5. Any assistance would be appreciated. Sheet1...
  8. How_Do_I

    Formula Help

    Can anyone see what is going wrong with my formula please? In this Jeanie I am getting the expected results. I made a copy of the workbook and added more data but now I'm getting a value error (see Jeanie in next post). Excel WorkbookA1302Item32SortNames in...
  9. How_Do_I

    Formula Help

    Here is a sample of my data, "Monday" will appear more than once in Column B but there will only be one Monday with "3" in Column A... How would I return the "01:05:03" to G2 please? Excel...
  10. serge

    Rearranging data.

    Hi All, I need a formula in cell AU9 to drag right and down, that will rearrange the data from AM9:AQ9 and would put the "S" first and then the "F" after, thank you.Excel WorkbookALAMANAOAPAQARASATAUAVAWAXAYAZ89SFFSFSSFFF10FSSFFSSFFF11SSFSSSSSSF12Sheet
  11. How_Do_I

    Average

    What formula would I use in B1 to find the average of "Mondays" with a value please. In the example the values are 10 and 5 so I'm looking for a return of 7.5 please. Excel WorkbookAB1Monday23Monday54Tuesday25Wednesday26Monday107Sunday28Monday9Tuesday2Sheet1
  12. mole999

    Puzzeld by result

    I have rota conversion tool (the plan changed so I ditched IF in favour of LOOKUP and INDEX methods, both provide unexpected results) Excel...
  13. James006

    Array Formula to get last occurrences

    Hello, Currently, as shown below in Sheet1 ... a helper column generates the True/False for all the last occurrences of the combined ranges : Names and Types Then, Column E allows to sum individual Types A,B,C ... The objective is to do without the Helper Column C ... in a combined Array...
  14. Sunline

    Average (Subtotal) , do not round up or down .

    Hello all , I have this basic average function but I have 4 x cells that are rounding up in yellow . I don’t want them to round up or down at all . Not sure how to do this . Thanks . Excel...
  15. How_Do_I

    Formula Help

    How would I go about this please. I want to count and extract the items that are not listed in my Jeanie. So count the items that do not contain AA11-AA14 and extract those items please. Excel WorkbookAAAB11Mounted Troops412Artillery1213Guards014Field Ambulances315Not the AboveSheet1
  16. How_Do_I

    Row Number

    Hello, how would I find the last row with 04-Jan-18 please? Excel WorkbookABCDE101-Jan-18201-Jan-18301-Jan-181stLast402-Jan-1802-Jan-1804-Jan-18Last Row541367803-Jan-18904-Jan-181004-Jan-181104-Jan-181204-Jan-181305-Jan-18Sheet1
  17. How_Do_I

    Count

    How would I do this please. I want to know how many cells in the range A1:D5 start with 28 and how many start with 57d. My Jeanie is a sample, I'm not after cells that contain 28 for example, whatever I'm trying to count must be from the left. Excel...
  18. etaf

    jeanie for office 365 on windows 10

    Hi, I have had a lot of issues getting jeanie to work on excel 2013 and windows 7 Now I have windows 10 and office 365 (excel 2016) How do i get jeanie to work looking at the links on various mods signatures - its only for windows 8 / 2013 versions Version 4.8 Excel Jeanie Html - Download...
  19. S

    Two way lookup (Sumproduct or other faster way)

    Source Data <tbody> A B C 1 Employee Item code. Items Sold 2 A 1 80 3 B 1 90 4 5 A 2 110 6 B 2 120 7 </tbody> Output <tbody> F G H 1 1 2 2 A 80 110 3 B 90 120 4 C </tbody> <tbody> Spreadsheet Formulas <tbody> Cell Formula G2...
  20. ask2tsp

    exceljeanie output looks ok in preview, mangled when posted

    Sheet1 <tbody> * A B C D E 1 2 3 4 5 label 2 * * * * 15 3 C 12,8 2,56 CCCCCCCCCCCC 30 </tbody> <tbody> Spreadsheet Formulas <tbody> Cell Formula A2 =IFERROR(INDEX(tblData,IFNA(MATCH($E2,indexList,0),""),A$1),"") </tbody> <tbody> Names in Formulas <tbody> Cell Name...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top