match index

V

vmjan02

Well-known Member
Joined
Aug 15, 2012
Messages
1,059
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2013
I have this data in 2 column, if a user enters a date the rows should have all the start time with respect to date

this function is not working
Excel Formula: 
=INDEX('Event Scheduler'!$E$3:$F$19,MATCH($F$1&"|"&ROW(A1),'Event Scheduler'!$E$3:$E$19),2)

any suggestion
DATEStart TIME
02-02-202210:00 AM
02-02-202210:30 AM
02-02-202212:00 PM
02-02-202212:30 PM
02-02-20222:00 PM
02-02-20223:00 PM
02-02-20223:30 PM
03-02-202210:00 AM
03-02-202210:30 AM
03-02-202210:00 AM
03-02-20221:20 PM
03-02-20222:00 PM
03-02-20224:10 PM
04-02-20229:45 AM
04-02-20229:45 AM
04-02-20221:20 PM
04-02-20222:10 PM
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
can you please share the table from where the result are being fetch.
 
Upvote 0
earthworm said:
can you please share the table from where the result are being fetch.
Click to expand...
DATE
Start TIME
End Time
02-02-202210:00 AM10:00 AM
02-02-202210:30 AM11:30 AM
02-02-202212:00 PM12:30 PM
02-02-202212:30 PM2:00 PM
02-02-20222:00 PM2:30 PM
02-02-20223:00 PM3:30 PM
02-02-20223:30 PM4:30 PM
03-02-202210:00 AM10:00 AM
03-02-202210:30 AM10:45 AM
03-02-202210:00 AM1:15 PM
03-02-20221:20 PM2:00 PM
03-02-20222:00 PM3:40 PM
03-02-20224:10 PM4:45 PM
04-02-20229:45 AM9:45 AM
04-02-20229:45 AM1:15 PM
04-02-20221:20 PM2:10 PM
04-02-20222:10 PM
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Calculate difference b/w numbers
Replies
3
Views
139
Peter_SSs
Peter_SSs
R
  • Solved
Transpose and combining data
Replies
9
Views
297
Fluff
Fluff
M
  • Question
suggest excel formula to calculate cumulative interest on no of days etc ......
Replies
1
Views
235
Peter_SSs
Peter_SSs
M
  • Question
Complexed Time Difference Formula
2
Replies
17
Views
1K
mahmed1
M
SaraWitch
  • Solved
Extract individual lines from cell
Replies
6
Views
239
SaraWitch
SaraWitch

Forum statistics

Threads
1,215,011
Messages
6,122,680
Members
449,091
Latest member
peppernaut

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top