Started 1 day, 6 hours ago (2008-11-18 01:05:00)
by Andy Roberts
I have two columns in excel. The first is a complete list of first names and the second contains several names. I have them both next to each other in a single spreadsheet. What I want to do is sort the 1st column alphabetically and then the second column sorts by matching to the first (this maybe easier to explain with an...

Started 1 day, 5 hours ago (2008-11-18 02:15:00)
by DALILA
HELP DESK http://www.helpdesksoftwarenewses.blogspot.com

Started 1 day, 16 hours ago (2008-11-17 15:15:00)
by S Buck
Hi excel users, i have x and y paramters which produce the relationship y = 2927.4x-0.8329, i've been asked if this relationship is significant..... i dont know, how do i find this out?? I'd be really grateful for any suggestions Cheers

Started 1 day, 13 hours ago (2008-11-17 17:43:00)
by Kceh
We currently have five teams which give us 24/7 coverage. A 12hr E/s and a 12hr N/S and a 7hr SP shift every five weeks. I have created a roster which allows for them to be rostered off 1 week in 5 or any multiple upwards to 10 in 50. (Rostered off 10 consecutive weeks of the year.) Does anybody else have an archive ...

Started 1 day, 12 hours ago (2008-11-17 18:25:00)
by Dean
I have a list of building data. Within that data, there are 15 unique towns. I want to know how many times a building of
a certain age group occurs in each town. There are 13 age groups. For example: Los Angeles - 1930 = 34,000 Santa Barbara - 1910 = 670 I have tried COUNTIF and other formulas, as well as advanced ...

Started 1 day, 15 hours ago (2008-11-17 15:51:00)
by Sandi
Hi, first time poster, so be kind. I've been working on coding a summary sheet that pulls data from worksheets in the active workbook. I'm almost done, but am stumped at writing some code that will loop through the columns that I have copied and total them. I recorded a macro, but
nothing happened when I ran it....

Started 1 day, 14 hours ago (2008-11-17 16:19:00)
by Skip
Received help a couple months ago. Lost my notes. How do I use $ to help speed changing ranges when using the RANK function? Skip

Started 2 days, 6 hours ago (2008-11-17 00:38:00)
by GeekBoy
I am trying to select a single column and paste one item into all the rows in that column. How can I do this? It is such a simple task in Google Document, but a nightmare in Excel 2007. I see you can use "fill" option, but that fills that column till the maximun capacity of Excel. Paste, and Paste Special are also worthless....

Started 1 day, 15 hours ago (2008-11-17 15:55:00)
by MPF
Thanks in advance for any assistance. On some machines, when a user opens an Excel file from SharePoint and checks out for edit and -does not- use the local drafts folder, you see a dialog with "File Conversion In Progress", then "Converter Failed To
Save File" message, but the file is checked out to the user and will not open in...

Started 2 days, 19 hours ago (2008-11-16 12:00:00)
by AS
Hi, I have following excel information and trying to copy information with heading to rows to new
worksheet with worksheet name to be display with employee id including additional column has information to count the number of record in that worksheet by employee id. Input file: Employee ID Employee Name ...
