General

Finding cell contents based on certain criteria
Hi, I have a problem that I can't quite seem to solve. I have a table of data, with names across the top in a header row and different categories as a "header column" (meaning to the left of the data in the table). i.e.: Category Jason Nick Josh Bryan . . . Age 20 ... 15 Mar 2006 14:53

Sorting Data in ascending order
Hi Guys, I need help in sorting a data in ascending order.Hope you guys can help me to solve it.:) Example: BEFORE SORTING: _Column_A_ _Column_B_ _Column_C_ David Student CS Andy Student ... 13 Mar 2006 20:12

I need to return mulitple results in several columns please help
How to look up a value in a list and return multiple corresponding values in each column. I can get the first column to work with this array: =IF(ISERROR(INDEX($N$1:$O$411,SMALL(IF($N$1:$N$411=$N$415,ROW($N$1:$N$411)),ROW(1:1)),2)),"",INDEX($N$1:$O$411,SMALL(IF($N$1:$N$411=$N$415,ROW($N$1:$N$411)),ROW(1:1)),2)) ... 13 Mar 2006 18:08

Displaying URL images in a spreadsheet
Is there is any way to get jpg images into excel cells that match a given url? ... 13 Mar 2006 17:05

can i export my excel page into a word doc?
I'm trying to turn the info I have on a exel spreadsheet into a word doc, any help? Please email me at cwinfree(a)lpbenergy.com ... 13 Mar 2006 13:56

Convert to Military time?
I am attempting to convert already existing data to military time. The existing data is dumped in from another program, and it currently looks like 5:58:08 a.m. and 3:01:29 p.m. I want them to show up 5:58:08 and 13:01:29 (without the a.m. and p.m.) Users are currently using the "replace all" option to convert th... 13 Mar 2006 13:25

Upper and lower Quartiles?
Nedd to know the formulas for upper and lower quartile from a set of data. Looked at the forumla quartile but im not sure whether thats entirely correct. ... 12 Mar 2006 15:06

combining data from several excel files into one file
I have several excel files (not worksheets within one file) that I want to combine into one excel file. In other words, I want to combine file1.xls, file2.xls, file3.xls, etc and put all of the data from all three of those files into one excel file. The data in each individual file is of the same information,... 12 Mar 2006 04:07

Adding Hours worked
I need to set up a calculated sheet that will add the before lunch hours with the after lunch hours, then divide by the 24 hour clock ... 12 Mar 2006 06:10

How many similarities is between excel and access
how many similarities is between excel and access? Which menus are common to both? Which keybroad shortcuts? Which formatting conventions? Which toolbar icons? ... 10 Mar 2006 22:41