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?
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...
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>...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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?
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...
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")
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.
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 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.