Replies

It’s not very hard to have them create their own Frequency tables and histograms. You can use the array function Frequency to create a Frequency Table.

Step one. Create what Excel calls bins. If you’ve got just a few different discrete values, those would be the bins. If you’ve got continuous data, you can take the max and the min and decide how many bins you want.
Step two. Select the area where you want the frequencies calculated. Type in =Frequency(data,bins). Use shift+Ctrl enter to enter the array formula. You should see the frequency table.
Step three. Make a column chart of the frequencies. You have to change a few settings. Under format series change the gap width to zero.

Attached are two examples of histograms from the same dataset.

There could be other issues as well, especially if it works in Outlook. It’s possible extra spaces or other extraneous information was copied from outlook. You can check and edit the hyperlink by going to the Insert tab and selecting Edit Hyperlink (in 2007). I don’t remember where it is in 2003, but you can use the shortcut CTRL-K, as well. You can also right click on a hyperlink. If it’s a “real” hyperlink, you see Edit Hyperlink on the drop down menu. You can make sure the link is specified correctly.

Not sure what happened. I’ll try again.

Here’s an example of the two ways I need the data. I tried using a pivot table, but since I don’t have values I couldn’t set it up.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

I have data in two columns, A and B. In column A each value is unique. In column B, I have 5 categories. I’d like to create a separate table beginning in column D with the categories in the first row, and each of the unique values under the appropriate category.

I’d also like to go back the other way. If I have 5 categories in the first row and the values listed below, I’d like to create a list with the values in one column and the associated categories in the other.

Thanks! I came up with this also: =VLOOKUP($I5,INDIRECT(“a”&MATCH($J$2,$B$1:$B$40,0)&”:d”&MATCH($J$2,$B$1:$B$40,1)),COLUMN($C:$C))

But your way is more flexible and easier to work with.

This is exactly what I need. As always, you rock! Thanks.

Thanks. That’s a good idea. They can reimage for me. My data is all backed-up, so they can get that set up also. Of course, it won’t

I do System restore regularly at home. However, our system administrators have disabled it at work. I’m not sure what the reasoning is. It’s bailed me out several times in the past.

How do you do image back-ups? Obviously that won’t work now since I haven’t done them. Sounds like something I should do!