2.60 FAQ-503 Is there a way to extract data from a worksheet based on conditions?
Wks-Query
Last Update: 8/7/2015
Yes. Select Worksheet: Worksheet Query. Please refer to Worksheet Query - Quick Start for more information.
Keywords:subset, reduce, reduction
- 2.50 FAQ-486 What should I do if the text label size on a worksheet created in Origin 8.5 appears much bigger when opening in later version?
- 2.51 FAQ-489 How can I easily identify a particular worksheet within a workbook that contains many?
- 2.52 FAQ-494 How do I find the average of multiple columns or data plots?
- 2.53 FAQ-495 How do I further process or plot results contained in report sheet tables?
- 2.54 FAQ-497 How do I use a parameter row or worksheet variable in the Set Column Values dialog?
- 2.55 FAQ-498 How do I use analysis results in the Set Values dialog?
- 2.56 FAQ-499 How do I auto fill cells with data?
- 2.57 FAQ-500 How do I sort my data?
- 2.58 FAQ-1059 How to get the row index and value of visible cell after filtering data in Origin?
- 2.59 FAQ-502 how do I take the value in a report to use in my worksheet
- 2.60 FAQ-503 Is there a way to extract data from a worksheet based on conditions?
- 2.61 FAQ-504 How do I reduce XY or XYZ dataset?
- 2.62 FAQ-616 What are the different methods to calculate average value in Origin?
- 2.63 FAQ-623 How to find the minimum or maximum value in a dataset and the corresponding x value and index number?
- 2.64 FAQ-662 How do I join two worksheets
- 2.65 FAQ-690 Two Quick Examples of Set Values dialog
- 2.66 FAQ-692 How to set values of a cell or a subrange?
- 2.67 FAQ-783 Can I select and hide worksheet columns by label or index?
- 2.68 FAQ-784 How can I use comma as decimal mark and use semicolon as function arguments separator in formula and script?
- 2.69 FAQ-794 How do I import date data from database?
- 2.70 FAQ-800 How to set up the SQL?