longer

Hello, Can you help me with the following. In excel I need to calculate how long somebody stays and a apply a different fee. between 1 and 7 nights 1,5 euro between 8 and 14 nights 2,1euro longer then 15 nights longer no extra charge. do you have an idea? please no vsb.. thanks alot

Having trouble finding the solution to this if there is a simple one. My formula looks like this: =COUNTIFS(Model,$A10,Package,$B10,Status,"*DS*") But it is not returning anything. I'm assuming this is because B10 contains varying numbers with 0's in front like "01" or "02" but the Package...

Hi Im using Excel 2010 Im sure that when i used a background option in the past it automatically defaulted to tiling it however this is no longer the case on my version can anyone tell me how to set my background so it is tiled cheers

Hi guys, I'm trying to work out a way for an entire row to automatically highlight if a cell containing a date is longer than 3 months ago. Here is part of my table: I'd like the whole of cell A9 to N9 to highlight in yellow for instance if the Contract start date is longer than 3 months...

I have a file that when being opened, the progress bar gets to about 60% and then pauses and the file takes around 2-3 minutes to open. The file is a template file and when data is added it can increase to around 18mb but when saving it takes even longer. I made some very minor changes to the...

Hi All, I have moved onto Excel 2010 and found that the Custom List limit is now around 1900 Characters (One list cannot be longer than this number). Which means that the Slicers I use, in combination with Custom Lists that are 4000+ Characters long, no longer work. I cannot find a fix for...

B

Hi, I no longer receive email notifications, is this just my problem? Would appreciate help Thanks A

Hi, I am trying to enter the following code so the following formula copies in column E but keep getting an error. The formula is about 3 times longer, I shortened it for the post. With Sheets("data") .Range("E9:E" & .Cells(.Rows.Count, "A").End(xlUp).Row).Formula ="...

Yesterday I changed my OS from Win7 to Win10, although not sure if that has anything to do with this issue in Excel... I have a series of macros which reside in my personal.xlsb file, that I have keys assigned to in my toolbars, that no longer work. If i hit these buttons I get the following...

Hi. I'm trying to just create a msgbox if there are any sheets hidden in the workbook. (This is part of a longer series of steps, so I want this prompt as a check.) Thanks.

Fellow sufferers My Excelsheet retrieves a lot of data into arrays. They stay in memory. Then a certain event (selecting a particular cell) is used to generate and display a graph (stacked bar). The problem now is: when the file is saved, then reopened, the arrays are no longer there. What is...

Hi, Sorry if this is trivial, but I can't internet search this properly cause it is difficult to explain my question to a search engine :( I am working on a capacity planning spreadsheet. If can do 100 units of work, but I know that if someone assigns me 100 units of work but it may be 50%...

For some unknown reason I can no longer open csv files downloaded from a well used site for many years with no issues. Error message reads "Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space...Have spent hours making sure I...

From what I understand there are many functions in the 2007 code that are no longer supported in 2016. Does anyone have a master list of things that no longer work in 2007 and what it needs to change to in 2016? Otherwise I would need to research every error individually. Example: DateToday =...

Is anyone else experiencing dramatically slower loading speeds on the forums since the update yesterday? It is taking a significantly longer time (upwards of 20-30 seconds) for any page to refresh or for a reply to post.

Hi I have a workbook that I have used for several years that successfully used the following code: Application.OnKey "*x", "CutValues" 'Intercept pressing of CMD+X keys. Application.OnKey "*v", "PasteValues" 'Intercept pressing of CMD+V keys. I have updated to the atrocious Excel 2016 for Mac...