Excel query a sheet of raw data and return
Closed
Brooster
-
Feb 25, 2011 at 02:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2011 at 09:12 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2011 at 09:12 AM
Related:
- Excel query a sheet of raw data and return
- Mark sheet in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to open excel sheet in notepad++ - Guide
- How to screenshot excel sheet - Guide
- Display two columns in data validation list but return only one - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 27, 2011 at 05:24 PM
Feb 27, 2011 at 05:24 PM
could you please upload a sample files WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.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.
Note: your data need not be to be real data but a good representative of how data looks like
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.
Note: your data need not be to be real data but a good representative of how data looks like
Thank you very much for your response. Here is the spreadsheet as you requested with some more information in the first tab on what I'm looking to do.
https://authentification.site/files/27128410/Greenblatt_Screen_-_February_2010.xlsx
https://authentification.site/files/27128410/Greenblatt_Screen_-_February_2010.xlsx
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 28, 2011 at 08:52 AM
Feb 28, 2011 at 08:52 AM
I would say the easiest approach would be that you filter the sheet on the parameters that you desire. Example >=100000000 and <=1000000000 to get 100M to 1B
then copy the resulting rows.
If the range changes, then perhaps you could make it more flexible by prompting the user to enter the range and then have it filter accordingly
then copy the resulting rows.
If the range changes, then perhaps you could make it more flexible by prompting the user to enter the range and then have it filter accordingly
Thank you again for your response.
If there's no function within excel to do it then I guess it can't be done. I'll have to figure out a way to get it into google doc's so I can use their 'QUERY' function as it seems to work.
Filtering isn't a good option for what I'm trying to do unfortunately.
Thanks for your help though
If there's no function within excel to do it then I guess it can't be done. I'll have to figure out a way to get it into google doc's so I can use their 'QUERY' function as it seems to work.
Filtering isn't a good option for what I'm trying to do unfortunately.
Thanks for your help though
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 28, 2011 at 09:12 AM
Feb 28, 2011 at 09:12 AM
I am pretty sure that there must be a way (though i am equally sure that will have memory issues). but unfortunately I am not aware of. May I ask why filter will not work in your case.