hello,
Im trying to input a formula on numbers to show data when I type in a specific time and date I should show then the number in that specific date and time. I’ve youtube and looked on apples support but I’ve had no success. I need help configuring a formula for the data that I have on my numbers sheet.
Please post a screenshot showing the data you have (so long as it is not personal, private data).
Here's how:
https://discussions.apple.com/docs/DOC-6591
For a filter, tapping a column letter (at the top after you've tapped in a table) then Column Actions... > Quick Filter or Add a Filter.
To sort, Column Actions ... > Sort Ascending or Sort Descending.
SG
I want to be able to put a start and end time and select a specific date to pull data from the other sheet
to to then show the end result here
in the number of transactions range.
In other terms I want to be able to put start time as a 11 am and end time as 12 pm. I can then select a specific date Monday 12/3 and pull that data range and have it display on the numbers per transaction range.
Have you considered using the sort and Filter functions on the original data table?
Could you possible show me an example? I see it in the table but how do I set that up?
I see a tab called Mondays Data But on date fields on that table shown.
Are you going to have multiple tabs, one for each day?
Is there more than one table on that sheet? Is data only recorded on Mondays? (i.e. weekly data)
I would have one data tab with a date/time column that would be used for SUMIF, COUNTIF, etc...
I added the chart to the data tab. So what I'm trying to formulate is I want to be able to put in a specific time range and the formula find the data on a specific day selected and out put it in the number of transactions range. Example I have Monday 12/10 selected as the day and 11am-12:30 pm as the time range. The number of transactions in the range should show 32 as the output automatically with the formula.
Numbers formulas
