Repeated number and multiple results
Solved/Closed
Sandeep
-
7 Sep 2010 à 11:55
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Sep 2010 à 07:22
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Sep 2010 à 07:22
Related:
- Repeated number and multiple results
- Mpc hc multiple instances - Guide
- Split excel sheet into multiple files - Guide
- How to delete multiple files on mac - Guide
- Excel multiple lines in one cell - Guide
- Multiple if statements in excel with text ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
8 Sep 2010 à 07:22
8 Sep 2010 à 07:22
there are many ways of doing this . There is even a complex formula but it may be difficult to modify it to suit your need. However I have parked a sample data sheet in the web page given below
http://www.speedyshare.com/files/24163155/sandeep.xls
the data is from A1 to B7
the macros are in vb editor module1
your have to run only the macro "finalmacro" . But all three macros must be parked in the module.
the results are in columns G,H,I.
for rechecking remove all the results except the data A1:B7. and rerun finalmacro
http://www.speedyshare.com/files/24163155/sandeep.xls
the data is from A1 to B7
the macros are in vb editor module1
your have to run only the macro "finalmacro" . But all three macros must be parked in the module.
the results are in columns G,H,I.
for rechecking remove all the results except the data A1:B7. and rerun finalmacro
