Help on VB
Closed
Saum
-
May 28, 2009 at 09:22 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 10:37 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 10:37 PM
Related:
- Help on VB
- Vb editor download - Download - IDE
- Vb select case - Guide
- Vb code maker aljzazy - Download - Other
- Vb round up - Guide
- Vb color codes list - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 28, 2009 at 10:37 PM
May 28, 2009 at 10:37 PM
Suppose you are comparing Column A & B in Sheet1 and then want values in Sheet2 ....
Write this formula in Sheet2 Cell A1 and drag it down only values of column! of sheet1 will appear which are > Column B ......
Sheet2!A1 =IF(Sheet1!A1>Sheet1!B1,Sheet1!A1,"")
Write this formula in Sheet2 Cell A1 and drag it down only values of column! of sheet1 will appear which are > Column B ......
Sheet2!A1 =IF(Sheet1!A1>Sheet1!B1,Sheet1!A1,"")
