Excel issue
Closed
sanober
-
Aug 15, 2010 at 05:47 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:45 PM
Related:
- Excel issue
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 16, 2010 at 05:56 AM
Aug 16, 2010 at 05:56 AM
you need another set of empty cells 20x200. In this range of empty cells if you type the formula in the first left hand cell then you can just copy that down and to the fight I have given a small example sheet which you can download from this web page
http://www.speedyshare.com/files/23821960/sanober.xls
suppose data is in A1 to A10 and B1 to b10 that is 10x2
now see the formula in D1.
copy D1 down upto D10 and also E1 to E10.(using control+c and control+v)
http://www.speedyshare.com/files/23821960/sanober.xls
suppose data is in A1 to A10 and B1 to b10 that is 10x2
now see the formula in D1.
copy D1 down upto D10 and also E1 to E10.(using control+c and control+v)
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 15, 2010 at 10:04 PM
Aug 15, 2010 at 10:04 PM
quote
comparing each entry with certain number (for eg :0.25) and if the entry is greater than 0.25 then function returns "yes" else it returns "
unquote
in an empty cell type this formula(suppose parent cell is A1)
=if(a1>0.25,"yes","")
comparing each entry with certain number (for eg :0.25) and if the entry is greater than 0.25 then function returns "yes" else it returns "
unquote
in an empty cell type this formula(suppose parent cell is A1)
=if(a1>0.25,"yes","")
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 17, 2010 at 11:45 PM
Aug 17, 2010 at 11:45 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
