Recent content by ArcherSteve

Thanks Gizmo, I'll go try that out.

Is it possible to print two records on one label? I have to print 200 numbers onto labels for ID purposes and I don't want to waste 200 labels if I can use 100. For example, I need the first label to be: BACKNUMBER BACKNUMBER 1 2 and the second label to be...

Holger, thanks again for your help, I really do appreciate it. I was toying around with the idea of concatenating but I really didn't want to. I guess that would be the easiest solution. Thanks again for the help.

Holger, wow. That works almost perfectly. There is just one slight problem, there a few father and sons in the data, who are in different divisions. Is there anyway to modify that code so that it looks at both "Last Name" and "First Name" columns? I've attached a new data file that has both...

Thanks for the reply shades.:cool: I've attached a copy of the data with last names and addresses removed. The first sheet, which is named "All', has all the people in it. The following 4 sheets have the people in the correct sheet (sorted by division). What I need to do is on the first...

Hey guys, I have a datafile being sent to me about once a week with various names in 5 different work sheets (4 sheets are individual categories and the last is all the data, which are people's names, on the one sheet)...(btw, not my choice....). Now what I need to do is have excel look at...

Anyone know of a good excel addin to do boxplots (also known as Box & Wisker plot), stem and leaf plots, dot plots? I've searched this forum and google and haven't found anything. I'd prefer freeware but I'll buy if I have to. Thanks again

that sounds like it would work! I'll try it asap. Thanks again.

I don't quite understand what you are suggesting. Could you explain it a little more? I'll try to look everything up in my books in the mean time. Thanks again

I have some data that is grouped in two columns, one is "Score Value" and the other is "Frequency" (or the number with that score). Since there are 1000 total scores, is there a way to data statistical analysis (like mean, mode median, etc) on this data without expanding the data to 1000...

In design mode, pull up the "Page footer" so that it's touching the text in the Detail. The width of the detail space defines the line spacing.

Thank you both for responding. I'll look into both.

I have an Access Database setup that sorts archery scores. I want to export a query to a specific sheet in an Excel file that is setup for playoff bracketing which has formulas that automatically advances the winner of a match to the next round. Now my question is, am I looking at this...

Thanks shades! Just what I was looking for!

Well, I found a major design flaw in my excel workbook. I made all my references relative when I need them to be absolute (ooops.....:o ). Instead of clicking on every cell and changing it, is there a way to change all the references on a sheet to absolute at once (i.e. change =A1 to =$A$1)...