| Thread | Last Post | Replies |
|
| Count filled data rows until empty | 21 Aug 2007 00:57 GMT | 6 |
In VBA, how can I count the filled cells in a column until the first empty cell? Thanks for any help, folks. =dman=
|
| Saving Excel Document to PDF | 21 Aug 2007 00:45 GMT | 4 |
I would like to save all my Sheets to one PDF. All can do right now is save each Excel Sheet individually. Could someone let me know how I can Save all of my information from the Excel Document to 1 PDF document.
|
| Sorting VLookup vs Sorting SumProduct | 21 Aug 2007 00:19 GMT | 1 |
How come I can sort a table with multiple columns of vlookup and retain the integrity of the data but I can't sort a table with multiple columns of sumproduct while retaining the integrity of the data. Any ideas?
|
| chose days by month | 21 Aug 2007 00:16 GMT | 1 |
I would like to write a function that is different for each month. My dates are written in dd/mm/yy format. i am looking for a way to reference the specific cells in a month without referencing day by day. For example i would write an IF statement like =IF(A1=(SOME DAY IN ...
|
| Pivot Table -- Text? | 20 Aug 2007 23:40 GMT | 1 |
I don't think this is possible, but thought I'd check to be sure. Can a pivot table display text values or must a pivot table do calculations and only display numbers?? I am basically trying to create a report from data I pulled from MS
|
| In Excel using URLs, how to display pictures stored on a server? | 20 Aug 2007 22:50 GMT | 1 |
For Excel 2003 SP2: I want to prepare an Excel report where the output rows have a photo and it's description. In each row, 1 cell is for the description, the next is the photo and the 3rd is for another person's comments about the photos on each
|
| Printing Problems | 20 Aug 2007 22:44 GMT | 2 |
i think that I must have hit the wrong button at the right time or something. Every time I try to print a particular spreadsheet a window pops up asking me to "Save As" the document as a Microsoft Document Imaging Format. If I save it as such and hit print again, the same ...
|
| IRR Problem | 20 Aug 2007 22:43 GMT | 1 |
I'm having difficulty calculating an IRR for a set of cash flows. The cash flows are as follows: -$450,000.00 -$70,107.78
|
| HOW DO I LOOK FOR A NUMBER IN A COLUMN IN A SPREADSHEET? | 20 Aug 2007 22:38 GMT | 3 |
i have rma numbers in column C, i only want to look through column, i want to type in the rma number when i receive it and the spreadsheet says here it is line whatever.... i just can not seem to get it to look for the number i type in and need to
|
| Excel 2002 Editing/Modifying a link | 20 Aug 2007 22:21 GMT | 1 |
This is one of many links that were created when opening an excel file from Lotus Notes. 'H:\DOCUME~1\sconklin\LOCALS~1\Temp\notesFFF692\[~5020587.xls]Aug 2 Pivot'!Z1432
|
| Tab status | 20 Aug 2007 22:09 GMT | 1 |
I have a status of Filter mode on one tab of a spreadsheet, this normaly reads ready, and now calutarions do not compute ? How can I reset this? There are no filters set on the spread sheet.
|
| Center on colon | 20 Aug 2007 21:54 GMT | 3 |
I have a table of times in the format "Time, 13:30" using Arial font. For asthetics, I decided to center the time in the cells. This results in the colons being out of line. Is there a way to center the cell on the colon? Similar to the "decimal tab stop" in Word that aligns ...
|
| help | 20 Aug 2007 21:53 GMT | 3 |
Does anyone have any suggestions on how to solve the following. P MCC A 589 1520 B 589 1520
|
| find by first two characters | 20 Aug 2007 21:47 GMT | 2 |
I have a list of rows that contain cells in a varying number of columns. The columns contain values like: 1-4895, 22-1456, 37-4568 etc. I would like to copy and separate these cells into columns based on the numbers to the left of the dash starting at 1, 22, 37 and so on. If the ...
|
| Copy from Two Cells | 20 Aug 2007 21:40 GMT | 5 |
I have two columns, each with a Vlookup to seperate spreadsheets. Each column will have either a "Y" or and #NA."Y" represnting that a client has enrolled in a meeting, #NA from Vlookup in either one or both columns if the client has not enrolled in either meeting.
|