I have two spread sheets, let's call them A and B. A could be considered the
master work sheet. It has 15 columns A -O. The B worksheet has 13 columns,
- Nov 21 Wed 2007 20:40
Combining spread sheet info
- Nov 21 Wed 2007 20:40
Hyperlinks
I am importing data from a web page into an excel worksheet. This data
contains hyperlinks, when I paste it in Excel I want to copy only the text,
- Nov 21 Wed 2007 20:40
Hide previously used items from multiple drop lists
I have been able to use the method at this web address to hide used
validation list items of a single list, www.contextures.com/xlDataVal03.html.
- Nov 21 Wed 2007 20:40
date formulas
hi,
i don't know how to compute a date formula to display someone's age. it will
- Nov 21 Wed 2007 20:40
Merge different first name, same last name, same address
I have 3291 names and addresses. In order to avoid creating duplicate
labels, I want to merge rows that have the same last name and street address
- Nov 21 Wed 2007 20:40
MSGraph Showing All Month-Ends as 30th.
Hi,
- Nov 21 Wed 2007 20:40
How can i write 2 lines of text in one cell?
Hello,
I would like to know how can i write 2 lines of text in one cell?
- Nov 21 Wed 2007 20:40
Right click on cell to set formula reference as absolute
If you can already do this please let me know, i get fed up with entering $
each time I want to make it an absolute reference
- Nov 21 Wed 2007 20:40
Need a function to convert value in its name
I need to get the name of a number. For example: I have in A1 cell a value,
25 and I need its name in the next cell B1, I mean, I need to get into B1
- Nov 21 Wed 2007 20:40
Trend Line Constants
I have created and X Y Scatter chart and placed an Exponential Trend Line on
it with a good R2 result. I have added the equation to be shown on the chart.