Need excell hel[p
Closed
mike
-
Feb 9, 2010 at 06:06 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2010 at 07:23 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2010 at 07:23 PM
Related:
- Need excell hel[p
- Excell download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 9, 2010 at 07:23 PM
Feb 9, 2010 at 07:23 PM
not clear
do you want to find out what are in columns a,b,c,d are when G in that row is greater than zero.
1. your data must have column headings in row no. 1 if not introduce row 1 and type the column heading, any heading would do
2. highlight the whole data
3.click data(menu)-filter-autofiltler
4.click the small arrow in column G at the column heading
5.in the download back choose "custom"
6. in the custom window in the left hand side window choose "greater than"
7.in the right hand side window type 0- that is zero number
8.click ok
you will only thos rows which has G column is positive.(more than zero)
you can highlight the filtered data and copy it anlywhere
9. then you again click data-filter-autofitler----filtering will be removed and you will gets the whole data.
If anything else you want post with complete examples.
do you want to find out what are in columns a,b,c,d are when G in that row is greater than zero.
1. your data must have column headings in row no. 1 if not introduce row 1 and type the column heading, any heading would do
2. highlight the whole data
3.click data(menu)-filter-autofiltler
4.click the small arrow in column G at the column heading
5.in the download back choose "custom"
6. in the custom window in the left hand side window choose "greater than"
7.in the right hand side window type 0- that is zero number
8.click ok
you will only thos rows which has G column is positive.(more than zero)
you can highlight the filtered data and copy it anlywhere
9. then you again click data-filter-autofitler----filtering will be removed and you will gets the whole data.
If anything else you want post with complete examples.
