Linked Questions
13 questions linked to/from Excel function to make SQL-like queries on worksheet data?
3
votes
1
answer
10k
views
Use SQL-style query in Excel using VBA
I have a large excel sheet which looks similar to this:
date | name | age | type
10/10/2012 | James | 12 | man
11/10/2012 | Jane | 50 | woman
12/10/2012 | Freddy | 2 | ...
- 6,820
0
votes
1
answer
7k
views
Import tables from a webpage to excel
I just have an upper-intermediate level of excel and intermediate background of VBA with excel. What I want to do is to import tables from a webpage like this which appears in the link: http://www....
- 2,195
1
vote
1
answer
5k
views
How can I write a database like query in excel using just functions?
I have some data that's structured in a table like this:
.
I have another tab on my spreadsheet where I eliminate any duplicate category entries and want to concatenate the data to look like this:
I ...
- 115
1
vote
1
answer
3k
views
Excel VBA Find All
As usual, I've wasted hours working on a problem before finally giving in and asking for help, so any help would be greatly appreciated!
I'm running a while loop on Sheet Test1 of my data in order to ...
- 876
0
votes
1
answer
4k
views
Alternatives to having multiple SUMIF formulas without requiring the user to apply a filter
Suppose in your workbook:
Sheet1 has a table with 20 columns and approx 1000 rows. Each row belongs to one of 50 categories. The developer cannot make any visible changes to Sheet1.
Sheet2 has a cell ...
- 6,529
0
votes
1
answer
4k
views
Sum of Max in PivotTable for Excel
I have a PivotTable that comes from the following table:
+---------+---+-----+
| A | B | C |
+-+---------+---+-----+
|1| Date |Id |Value|
+-+---------+---+-----+
|2|4/01/...
- 456
0
votes
0
answers
714
views
Excel VBA using SQL Datediff
Hi I have an Excel sheet with quite a number of data inside, and now I want to perform queries directly in the sheet using VBA. One query is to find the recurring users, so when I implemented it in ...
- 527
1
vote
1
answer
434
views
Use excel workbook like a function
I found this on a related subject - Excel function to make SQL-like queries on worksheet data?
But I was wondering if there is any way to use an excel workbook/file like a function in a separate ...
- 23
0
votes
1
answer
303
views
execute sql query on excel columns using vba
I'm doing excel data verification and would like to view any discrepancies within each column. And I think executing
"select distinct column1 from table_name"
is efficient.
Is there a way to do that ...
- 37
1
vote
4
answers
185
views
Searching collections
I'm working with a rather large dataset (>100,000 rows) and trying to compare two lists to figure out which items in the new list are not already in the master list. In other words I want to find the ...
- 29
0
votes
1
answer
110
views
vba excel datetime innerjoin
I have a excel where i read a dbf file with a select. I want to select the last datetime from each code_id.
Code_id daytime
1 12-01-2016 9:58:12
1 12-01-2016 10:01:12
2 12-01-2016 10:54:01
...
- 59
0
votes
1
answer
80
views
SQL function in Excel
How can I use an SQL function that gives me a table in Excel. I looked everywhere and couldn't find a solution.
Thanks in advance
- 101
-1
votes
1
answer
76
views
Count row with multiple values in excel
I have excel sheet contain 600 thousand row, I want to select one column.
for example please see the attachment picture
Here in the column there are multiple values, I want to count it and the ...
- 29