Questions tagged [excel]

For questions about data related to a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

How to open a zip folder's metadata as .CSV?

I'm working with a less than great reporting platform. Certain users of our system were expected to upload a certain document by a specific date. If they had not, they were sent a reminder. We are ...
0
votes
1answer
19 views

R or Excel: Calculate difference between dates

I have a list of course completion dates (person, start, end) in the following format (exemplary): Person X || Sept 21, 2021 06:30 PM || Sept 21, 2021 06:50 PM Now I'd like to calculate the overall ...
0
votes
0answers
7 views

Counting Cells of a Particular Format in Excel

I want to be able to count all cells of a particular format in one column given a condition in Microsoft Excel. When I use the CELL("format", [cell]) command, all cells in that column are of ...
2
votes
1answer
42 views

How to look up the Census Block Code of an address?

I am trying to divide up a pool of addresses currently in Microsoft Excel according to the Census Block Code. Would anyone tell me where can I access data like that? Any instructions? Moreover, is it ...
1
vote
1answer
502 views

Database with multiple values for the same ID

I have a database where each entity has a unique ID, but recently all of the entity names were changed (not in the same way) to improve readability. This has made a lot of the summary reports look ...
3
votes
3answers
289 views

wikidata extract

I have a list of wikidata entity IDs (i.e. Tour Eiffel Q243, Big Ben Q41225...), and a list of properties (i.e. coordinates P625, country P18 ...). Is there any way to gather and extract in Excel (or ...
3
votes
1answer
270 views

Extracting variables from unstructured Excel files [closed]

I have hundreds of Excel files (databases) from which I want to extract a subset of variables. The data are not systematically in the same cell (e.g. G4) and also don't always start on the same row. ...
6
votes
1answer
363 views

Finding tables in messy structured Excel / csv file to import them in DB

we have a lot of messy structured excel files containing tables somewhere on a sheet and we want to import these tables into a database to do some analytic on it. There problem is that we don't have ...
3
votes
1answer
220 views

Australia Hotel/Motel Data

I am wondering if there is anyone here that either has 2013-2015 list of hotels in Australia with contact phone numbers and if it had emails that would be a bonus. I am currently putting an excel ...
2
votes
1answer
594 views

Getting more than 100 records from OpenFDA in MS Excel [duplicate]

I have a query that appears to identify 975 items per the meta information. I used the limit (100) & skip (25) parameters to get the result. However, if I try to use that same query in Excel (...