lost

  1. O

    Keep the Copy Function

    Recently my employer upgraded my excel to 2016. It now has this function that saves your copy even after you perform another function. Where as before you lost you copy area and could not paste once you did something else. Does anyone know how to turn this off?
  2. G

    Displaying % in power BI

    My data is structured as below (snippet of data) <tbody> ID Location Status AP001 Location5 Booked AP002 Location3 Pending AP003 Location2 Lost AP004 Location7 Lost AP005 Location4 Booked AP006 Location2 Lost AP007 Location6 Lost AP008 Location1 Booked AP009 Location7 Lost...
  3. O

    Can you have multiple If functions in one cell

    Hi, Can you use multiple IF function formulas in one cell to return a specific value? Im looking for a formula that will return a value of 'Win, Draw, Lost' from a result. <colgroup><col span="4"></colgroup><tbody> Friendly 2 TEAM NAMES Team Scores Navy U9 3 Yellow U9 2 </tbody>...
  4. R

    List of Lost Cutomers

    Hi, I am using Excel 2007. I want to populate list of customers whom I have lost and are no longer buying from me. I have a huge table with more than 760 customers in listed in Column C from C7 to C2500. In Column H, I have date on which they had purchased. Most of them are repeat customers...
  5. A

    Lost an Object While Moving Frames Around My Userform

    I have designed a pretty complicated userform. In my process of tweaking it through the VBA interface (moving frames full of obects), I seem to have lost a textbox object. I had a textbox named tb_comment2. It was within a frame (frame116), which was in itself nested in another frame...
  6. F

    Slicer adjustment

    Hi I am compiling a slicer based dashboard on working days lost due to sickness. I have generated a pivot table with all the necessary data I need from one single source. However, when I have generated my slicers, I have one for AWDL (days lost) and this only shows individual totals. Is there a...
  7. W

    5 highest values with multiple criterias and possible tie

    Hi, looked for forum to find answer for my question but didn't manage to find solution. I would like to find 5 top values from data, based on certain criteria. I also need way to present results, if there is a tie between 2 values, when status is same for both (for example companies: Foxtrot and...
  8. T

    formula to tell me which word in a column is the most popular

    Hi Everyone, i have a shhet and down column f we choose between 3 words "Sold", "lost" and "free" All i want is a formula to tell me which of those three words has been used the most so count number of "Sold", "lost" and "free" and if "free" is the highest give me the word "Free" etc. please...
  9. N

    problem with lost sheets in 2003 excel file.

    Hello Friends, before anything let me tell you that I am not a regular computer user, I use computers since 1984, I like to build them and I regularly solve most of the problems I found with the software in my daily basis. In 2008 I found what seemed an unreported bug in excel 2007 In those days...
  10. S

    Multiple if/and critera

    Good afternoon ladies and gentlemen. I am looking for a formula which will return a different cell value based on two IF\AND criteria. i.e I have three columns in the worksheet and one of the cells in one of the three columns titled "live", "lost" "won" (AB, AC, & AD). There will be a...
  11. T

    VBA Issue Saving File With VBA, Formulas & Drop Down Lists

    Hi all, I am have issues saving a workbook in a different location as a backup to the original however when using the code below I am finding that some of the detail is being lost. Can anybody help with the code as I can see there are various settings that can be chosen. ActiveWorkbook.SaveAs...
  12. S

    Pivot table filters lost

    Hi all, I have made a dashboard consisting of pivot tables filtered by day of the week. I wanted to have a master copy that I could dump data in from an external source. When I remove the data used to create the pivots and replace with the new weeks data, the filters are lost and I have to...
  13. L

    Need help automating tasks in Excel

    I have a mental block when it comes to VBA and am on a timeframe to get myspreadsheet working properly. When a date is entered into Column H, I need the row to be lined through and then moved to the bottom of the list. I think this should be a simple thing to do but am lost. To boot, I can't...
  14. J

    lost print size

    I have lost the setting to print 8.5 x 14 sheets ! how do I recover this setting ? THANKS
  15. M

    Losing ADODB.Connection

    I am using the following to create a connection to an Access Db file via the Workbook_Open procedure in ThisWorkbookSet cnConnection = CreateObject("ADODB.Connection") strDbName = ThisWorkbook.Path & "\" & strDbFile cnConnection.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strDbName...
  16. M

    Lost a new thread post - where do auto saves go?

    Lost a new thread post - where do auto saves go? i answered the phone after three minutes went back and posted by question but it's not anywhere to be seen. Looks like my session timed out. But I always see the auto saved popup - so where do I go to find the original post?
  17. C

    if area between and numbe rof bedroom then value

    Hi All I am trying to do the following If area required is 83, with 3 bedrooms. then the value required is 60000 a B C D E F G H 1 areas bedrooms 2 1 2...
  18. E

    Greater than and Less than Operator

    Ive got a working formula here where I am seeing if something is greater than 74% right now and want to also say less than 100% (1). How would I adjust this formula to do that? =SUMIFS(Z$6:Z$9711,$F$6:$F$9711,">.74",$D$6:$D$9711,"<>Lost")
  19. P

    Count between dates

    Column A has dates for the past 5 years. Column B has numbers. I want to know how many numbers are between particular dates that I can specify. Completely lost. Send help.
  20. J

    Excel Data Validation on selection of values in one other cell

    Hi I have a list in A1 (New, Quoted, Won, Lost, cancelled) etc. In A2 I want to enter the date this quote has been closed. It must be validated by looking at A1 and can only accept the date if A1 is either Won, Lost or Cancelled. I tried the =And(A1="Won",A1="Lost",A1="Cancelled") and...

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