create an expense requisition form Can you please help me to learn how to create an expense requisition form? thanks, ml ... 14 May 2010 18:20 =MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3))) =MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3))) I am trying to do this exact same formula, however, I need my array to calculate across columns instead of rows, I have substituted ROW with COLUMN but I get 0.00's. Any advice? Shane Devenshire wrote: There is one significant difference, try 01-Feb-10 There i... 14 May 2010 20:31 Sorting in a Pivot Table unselected fields When I create a Pivot Table with a list of about 10 suppliers. Why does the feild I unselect disapear from the Pivot Table? If I want to view the suplier I have unselected I need to add it back to the table. I want to avoid doing this. Any ideas? ... 14 May 2010 19:26 if-then statements or functions I have a 2 sheet workbook. If cell 'sheet1 b7' has a certain word typed into it I want 'sheet2 b2' to return the value in 'sheet 1 b8'. Can I do this? How? Thanx ... 14 May 2010 16:09 conditional count Any simple way to count how many 1s and how many 2s here? 2 1 2 2 2 1 2 1 1 2 1 1 ... 14 May 2010 20:31 Cell Referencing I have Worksheets("Data") and worksheets named for each year ONLY the current year and previous years are available, ie Worksheets("2011") will not exist until it is 2011. Worksheets("Data") is a summary worksheet. It pulls totals and/or averages from each year worksheet. Since future year worksheets do not... 16 May 2010 10:15 Text Functions I'm trying to split a text string ... Apart from it not working quite right yet! I'm sure I've over complicated it. Base Data "Path": \\SERVER\X\$\data\Team Name\Personal Data\JOE BLOGGS\mail\ \\SERVER\X\$\ \\SERVER\X\$\RECYCLER\ \\SERVER\X\$\\$Extend\ \\SERVER\X\$\\$Extend\Test I'm trying to split into High Le... 19 May 2010 16:03 Excel worksheet made exclusive Exit the worksheet. Have another user go in and set it to shared. Somehow, this seems to work out whatever is confusing Excel. You should now be able to go back in and it's shared. Diane M wrote: Error message 'This book has been made exclusive by jdoe' 11-Mar-09 I was attempting to share a workbook. I ... 19 May 2010 11:35 Can a pivot table be redirected to an external source? I have already built an extensive file using multiple pivot tables where the source data is contained within the same workbook; however, due to file size and several other factors, I now need to separate the source data into its own file and have all the pivot tables pull from the external source. To complicat... 14 May 2010 13:56 Column Lookup? I have reference data in Column "\$Q\$3:\$Q\$502" of "sheet1". For all cells in the reference column that contain "yes", I would like to average quantity in cells for Column \$S\$3:\$S\$502 respectively. So if it finds 3 in column Q with "Yes" (2,3,4) , it will return the number 3. -- Thank you! ... 14 May 2010 20:31