Functions

Using a cell's value to copy another cells info to another workshe
I am not sure that this is possible, but I will ask. I am running a bowling tournament that has many teams (2 people/team) over several shifts. These teams will be placed in two divisions. I want to list each shift's teams on a seperate worksheet while combining these into a "Tourney Standings" sheet for eac... 16 Mar 2010 17:26

If and LOOKUP - results in multiple columns
I want to lookup a value in a table, then return a value to a different column based on the result. For example: Sheet 1 has: col A ------ 1 2 3 4 Sheet 2 (LOOKUP table) has: col A col B ------ ------ 1 Apple 2 Banana 3 C... 16 Mar 2010 23:14

Help with SumProduct
Is there a function in excel that would allow me to replace the $2000 in the formular below with the last row in the column contain values. Somthing like this, in VBA: errorWS_lastRow = errorWS.Cells(Rows.Count, "A").End(xlUp).Row =SUMPRODUCT((Current_MarketList!$I$5:$I$2000<$T$5)*(Current_MarketList!$K$5:$K$200... 17 Mar 2010 21:13

Excel 2007 - worksheets macro
Hello. I am using excel 2007, and i am still a beginner, so i would like to ask for your help for making the following: a macro which adds a list with the available worksheets in the current workbook, within the context menu. The selected sheet from the context menu, must become active. Thank you. -- vers... 16 Mar 2010 17:26

Using spreadsheet to fill in forms
We need to create a form of an invoice in a very specific format (determined by an international shipping company). We will have several items which will need to be filled in on every invoice. We would like to be able to fill in all the pertinent invoice information on a spreadsheet and have each line populat... 16 Mar 2010 17:26

Excel Sorting
I did not create the worksheet, but need to sort the data. Get a message saying " This operation requires the merged cells to be identically sized" An excell newby, and help doesn't help. Help?? ... 16 Mar 2010 15:07

sorting grouped cells
Is it possible to sort grouped cells? I have a sheet designed for volleyball stats where total stats show when all the individual game cells are collapsed, and I want to sort the total stats rows and have all the grouped data also be sorted. ... 16 Mar 2010 16:17

Copying values/formulas from only visable lines when filters are o
I have huge spreadsheet with dozens of columns, and filters are on most columns. In my last column, I want to systematically post the results only of specific lines while specific (and sometimes multiple) filters are on. Also, the last column is filtered for "blanks" only, so if a line already has a value f... 16 Mar 2010 13:58

return different values based on 4 criteria?
Need Formula or macro to allocate the "Scheduled hours" based on Group Counts: If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C" should both be 6 hours If Group "A" and "C" are equal to or less than 0, then Scheduled "A" and "C" should both be 0 hours If Group "A" greater than 1, a... 16 Mar 2010 18:37

Sharing workbook
When i try to start sharing a workbook i get immediately the message: "The file is no longer shared". The file cant be saved anymore and so sharing is impossible. I use excel 2007 on XP with all current updates. Workbook is not big (41kb) and restarting excel does not work. Any suggestions?? Thanks,... 18 Mar 2010 13:01