| Thread | Last Post | Replies |
|
| vlookup on 2 columns | 11 Jul 2006 16:30 GMT | 18 |
hi trying to vlookup on 2 culomns but im sure its not the way i need to compare 1 culomn find all the data there and with this to compare another data in another culomn based on this 2 to bring data from third culomn
|
| add minutes to a given time | 11 Jul 2006 16:14 GMT | 3 |
Hey there, in cell A2 I have a time, say 07:00 hrs. In B1 in have i.e. 3 minutes of time an operation takes. Now I want to add those 3 minutes to the time in A2, so I have 07:03 hrs in cell B2
|
| sum question | 11 Jul 2006 16:06 GMT | 4 |
Here is what I have $130.39 $52.90 CR $16.00
|
| compare 2 lists and common ones display on the 3rd column | 11 Jul 2006 15:48 GMT | 3 |
Is there a way to compare data in 2 columns, and display the same ones that occur in both lists to a 3rd column? Thanks. Elaine.
|
| create a new tab | 11 Jul 2006 15:02 GMT | 1 |
I have 4 payroll sheets and I need to have each one as a tab on my screen. I simply have one and not the others. How do I create a tab for each of the 4 documents that I need?
|
| Excel into webpage | 11 Jul 2006 14:54 GMT | 1 |
Is there a way to insert an excel file into a webpage which will allow visitors to enter data, view results, but not download the source program. The information I am posting is somewhat sensitive and will be password protected access. My concern is visitors downloading the file
|
| How do I clear a form without a button | 11 Jul 2006 13:01 GMT | 4 |
I have the following cmdOK button for a form. Private Sub cmdOK_Click() Sheets("Band Members").Select Range("Last_Name").Select
|
| Cell (Border Only) Protection | 11 Jul 2006 12:50 GMT | 1 |
How do I protect the border (format) of a cell? Is it possible? I'm currently using Excel 2002. Thanks.
|
| Advice on comparing data sets | 11 Jul 2006 12:44 GMT | 1 |
Can anyone advise on how I can compare data on 1 sheet with dat compared on another. Example attached. I want to be able to show that whenever the UK is shown (can appea multiple times) on this sheet it checks on sheet2 and enter th
|
| grouping and subtotal by month | 11 Jul 2006 12:33 GMT | 1 |
Hi i want know how to count subtotals based on month. Please see the below description' I have three sheets in excel.
|
| Dynamically changing a link name | 11 Jul 2006 08:39 GMT | 4 |
is it possible to include a variable in a formula that gives you the option to pick out a different file name? eg.. Weekly Reports are created with just the last 6 characters of the file name changing each time a new report is created. ... eg. WR010106,
|
| data from a formula direcly to a variable | 11 Jul 2006 08:32 GMT | 8 |
i'm using formulaarray but i would like to save time and direcly the data from the formula to transfer to variable instead on having in on a cell, it a metter of saving time and machine time
|
| how to delete right rows? | 11 Jul 2006 08:27 GMT | 3 |
I have quite complicated problem. I have sheet where I have items in rows which have many values in columns. values needed here are "level" and "class" Level is number value between 1-10 and Class can be "Major" / "Minor".
|
| How to delete specific row from sheet? | 11 Jul 2006 06:52 GMT | 5 |
How this differs from all other posts like this is that I want a function that deletes certain row, like "1" or "100", by given row number. Not with specific criteria. Something like this. =IF(something;deleteRow(3);0)
|
| Stuck macro | 11 Jul 2006 06:19 GMT | 2 |
I have a list of Business names with their Address locations directly in the cell below, i.e. Business Name Address Business Name
|