I have a sorted data of 450 learners with name and percentage. Columns are Name Percentage Result Mac 86 Pass Richard 67 ...

I have a sorted data of 450 learners with name and percentage. Columns are Name Percentage Result Mac 86 Pass Richard 67 ...

In the future, put your question in the body of the message, please. We cannot respond to empty messages (title only). Assume your numbers are in column A,...

Hello all Hoping to get some insight on linking a workbook to multiple worksheets My problem is as follows: I wish to link cell B26 from a workbook named...

How can I get a cell to give required warnings if other cells are out of range. Warnings to show in Cell M8. Cells B8= 1960 C8= 1860 B39= 81 . I need...

Have a list of states in one column and I want to count how many times a value appears in another column. My example is this I have a range of numbers in...

Hi I run Excel 2K Does anyone have some VB code that forces a form to open to the maximum screen size available. Also, where would I put the code if it is...

Excell 2007 - New user Can someone help me with the formula to keep a range of dates with the same month and day, but update the year to the current year? ...

Hello. How can make a cell show the current monht? So for if its October it shows the number 10 in a cell? I've tried data, today, etc... the closest I've...

I have macros which manipulate the data. I am trying to find a value which I know is in the data, but find won't find it. I have tried using a value in a...

I have uploaded an excell spreadsheet and seem that all cells are text formatted. I can`t change to fromat of cell to number. "Format cell" dosen`t working or...

I work for an airline and sometimes I need to know the total hours of a delay, and when the delay is greater than 24 hours. In my report I hav something like...

Is there anyway I can set up a system where if I type a variable ( alpha numeric/numeric) in say d1, it will automatically put strings assigned to this...

I have a set of 5 macros which analyse and finally format data. It starts with about 5000 records and ends up with around 250. I have one "super" macro which...

i made a list for a drop down box,I have 40 items counting the title of the box.I used the data validation button & the box works fine.all 40 items are in...

Hi there, My spreadsheet tracks and measures the performance of tasks. In Column B, I have a list of start times in the time format hh:mm in two other...

Hi - I want to hyperlink within the same Excel sheet. When I do, the destination cell appears at the bottom of the screen. How do I get it to appear at the...

Is there a way to divide a cell in multiple rows? I am not talking about the insert the Text Box or table. The cell it self should be able to take text in...

Excel seems to almost freeze up and a blue circle is rotating. Up at top of screen it says "not responding". why is this happening? This is brand new...