by Felix Brun » Thu, 18 Sep 2003 01:02:28
by Alex Mitch » Fri, 19 Sep 2003 00:45:12
1. Change color of row (Col A thru Col Q) based on text value in Col J
2. Rows & Cols - copy formulas in Col A to # rows in Col B
3. Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B
4. Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val
5. Which table design more is correct - more cols/less rows or less cols/more rows?
6. Which table design is better - more cols/less rows or less cols/more rows?
7. Compare Col A and Col M, if Match, Copy Col N to Col E
8. find text from 1 col in 2nd col & return value from 3rd col
9. Trying to average col c if col a = "value" and col b = "value2"
10. How can I create a table w/ 5 cols. & 2/rows, then sort col 5 to
11. sum values in a col only if value in next col is desired value
12. 200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC
13. Cross match data in Col A v/s Col B and display match in Col 3
14. write macro col A date Col B gas col C dollars