happened

I’m trying to use a bunch of if / and statements to work on the following problem but it isn’t really getting me anywhere. The premise of what I’m working on is that certain things have taken place in the past, and depending on how long ago it happened, it gets a certain score. - If it...

When you open a spreadsheet the top is always shows the columns as A, B, C, D... and the rows are always number 1,2,3,4.. When I click in a column the "Letters" and changing to numbers. I have never seen Excel do this. What's is happening to my spreadsheet??? It happened right after I ran...

Hello This is something that has happened to me some times but never understood why. I'm doing a simple calculation which I can easily do in my head, and the answer should be 0 but excel returns a negative 0. Upon further inspection the 14th decimal position has a value, but it should be 0...

I somehow got the following corrupted language in the formula of my cells..... C:\Users\Owner\AppData\Roaming\Microsoft\Excel\ I have 2 spreadsheets that communicate with each other. This happened often a few years ago, but hasn't happened again since this past week. what am I doing wrong...

Hi I've got two questions: 1) I've got an Excel file where if I right-click on a tab then click 'delete' (to delete the tab), nothing happens! Has this happened to anyone else? 2) when I try to sort data in a different tab in the same file, it doesn't sort! There are only three columns -...

I have a large spreadsheet with events that have happened, noting (across the row) the time and a lot of information about that event. I wish to add a column that counts how many times an event has happened in the last given amount of time. So, for example, in the following spreadsheet where...

Dear All, If A5 is empty and B5=5, I wrote IF statement like this (IF (A5="", B5,), but nothing happened and A5 still empty

I have a column, which I enter in a percentage (formatted that way) if I add 100, it used to appear as 100% which is how I want it, now though for some reason it shows as 10000%, this has only happened recently and seems to be happening to all workbooks opened on this PC which makes me think a...

I've tried to use the following formula with out any success.=if($a5<>"",vlookup($a5,'master sheet'!$1:$1048576,2,"") The error shows it to be $1. I'm not sure why this has happened as I've used this formula in another work book.

Hi, I was working on a workbook and all of a sudden it began to run slow, "Calculating 4 processors" for a long time. I've tried deleting all the cells to the right and below but it's still the same. I have other workbooks with the same type of sheets/formatting on it but they are fine. The...

Hi, I created a formula/reference to another worksheet. The problem is that instead of displaying the value of the reference it displays the text of the formula. How can I fix this? This has happened before. A1 = Sheet1!B4 where Sheet1!B4 = "Animal" It does not display "Animal" in cell...

After ive have been linking over 100 cells between 2 different excel files, all of a sudden, my links all went #REF! and I have to start over :( =VLOOKUP(D459;'[1. Speedo Cases GEM 170728.xlsx]speedo'!$B$10:$FZ$115;3;FALSE) became =VLOOKUP(D483;#REF!;3;FALSE) Any one has an idea how this...