match index

V

vmjan02

Well-known Member
Joined
Aug 15, 2012
Messages
1,062
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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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

M
  • Solved
Formula Help.
Replies
3
Views
109
Fluff
Fluff
C
  • Solved
Calculate difference b/w numbers
Replies
3
Views
162
Peter_SSs
Peter_SSs
R
  • Solved
Transpose and combining data
Replies
9
Views
300
Fluff
Fluff
M
  • Question
suggest excel formula to calculate cumulative interest on no of days etc ......
Replies
1
Views
269
Peter_SSs
Peter_SSs
M
  • Question
Complexed Time Difference Formula
2
Replies
17
Views
1K
mahmed1
M

Forum statistics

Threads
1,215,492
Messages
6,125,115
Members
449,206
Latest member
burgsrus

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