| Thread | Last Post | Replies |
|
| Paying fee to someone who could extract data from web-page to excel! | 09 Jul 2007 01:29 GMT | 1 |
what i would like to have is ability to transfer/extract somehow organized data from this web-page: www.betbrain.com into excel format. But - only some data which i want and what is important to me and want to have them sorted into colons. To be precise, for any match(game) on
|
| IF 5 years old by Dec 1 they will start Kindergarten | 09 Jul 2007 00:58 GMT | 4 |
I am looking for help to determine a formula that will let me determine which children who will be 5 years old by Dec 1, 2007. Col A [FirstName]
|
| remove hyphens from a list of part numbers | 09 Jul 2007 00:15 GMT | 1 |
I have a column containng 1000 part numbers. Each part number contains a hyphen (example 0012-3322). Is there a formula or rule for removing the hyphen from all of the part numbers?
|
| Vlookup | 08 Jul 2007 23:48 GMT | 10 |
In another worksheet, I have a table sorted in ascending order. Table has four columns. The first column has my lookup information in it, and the other three, is the informatin that I am trying to get into another workbook. But all I get is #N/A.
|
| Excel 2007 question? | 08 Jul 2007 23:28 GMT | 4 |
Are there any compatibility issues when transitioning from Excel 2002 to Excel 2007? I just bought 2007 but haven't installed it yet. I'll assume that all of my worksheets and formulas will work just the same? I'll also assume that if I send a 2007 spreadsheet to someone with an ...
|
| How to use goal seek | 08 Jul 2007 23:10 GMT | 2 |
Can u pls tell me how to use Goal Seek function in excel sheet. rgds, Manu
|
| Worksheet function match - run time error | 08 Jul 2007 22:30 GMT | 3 |
Why does the statement give a run time error If IsError(Application.WorksheetFunction.Match(chk_hdr1, hdr_rng2, 0)) Then where chk_hdr1 is a variable and hdr_rng2 is a column range name. It gives the run time error 1004,
|
| range,cell refrence | 08 Jul 2007 18:30 GMT | 3 |
Using excel 2007. I have a range consisting of 12 cells (monthly total results) in a column that progressively changes in value as the year progresses. I want to automatically reference ONLY the cell corresponding to the current month. The following month the cell in the range ...
|
| conditional formating | 08 Jul 2007 16:36 GMT | 7 |
how to change the color of the font if the day is Sunday? ( i tried the following formating and it dIdn"t work: CELL VALUE IS "EQUAL TO" =WEEKDAY(A7,1)=1 nk
|
| Conditional Formatting for Duplicates | 08 Jul 2007 14:32 GMT | 2 |
I have 4 distinct columns that need to be anlalyzed for duplicate data using conditional formats. I want to write a function that will look at each value in the columns and determine if there are duplicates and overlap in times. Column A has serial number, column B has city ...
|
| Negative Column ???? | 08 Jul 2007 12:30 GMT | 5 |
I'm trying to work something out and I am trying to find out if something is possible... Basically I do the losses and gains at work for various stocks - I manually work out the losses and gains, recording them on a weekly basis.
|
| Maximum Columns in Worksheet | 08 Jul 2007 11:34 GMT | 11 |
The testing department wants me to assist them in a large project that should be written in "C". However I will give it a shot! They want a Worksheet that is going to require 426 to 434 Columns. First Question: Is that possible?
|
| Update reference in multiple formulas | 08 Jul 2007 10:04 GMT | 3 |
I’ve set up a few tables to with formulas to extract data from a large spread sheet which is produced every month. I’m using Vlookup but every month the “table_array” part of the formula will need to be changed. Is there a way to update the “table_array” part for all the ...
|
| Cell Reference | 08 Jul 2007 09:00 GMT | 2 |
Is there a function or formula i can use to look up a value and then display the cell reference ie C4? Many thanks Luke
|
| formulation setup() from 2003 good for 2007 | 08 Jul 2007 03:50 GMT | 2 |
In my workbook excel 2003, i have my spreadsheets with formulas in cells along the last column and the last row and specifically on IV65536... these are part of circular formulation - catching errors and sums and cross-check by color coded conditional formats....
|