Reputation
5,293
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
21 58 113
Impact
~1.5m people reached

May
18
comment Return data based on matching date range
I'm not much familiar with INDEX & MATCH, except that they're supposed to be superior in certain ways to VLOOKUP. That said, I think this is how I'd implement your suggestion with VLOOKUP, that also allows for easy coverage of Previous & Next: 1. C2=IF(C1="Current","Next",IF(C3="Current","Previous",IF(AND(NOW()>A2,NOW()<B2),‌​"Current",""))). 2. Copy C2 down to the end. 3. For "Current" we'd do =VLOOKUP(C:D,"Current",2,FALSE). 4. Write similar formulas as in 3, for "Previous" & "Next".
May
18
asked Return data based on matching date range
May
13
awarded  Famous Question
May
4
comment Dynamic monthly excel calendar
Fair enough. But most of the same people think "Computer" == "Windows PC". ;-)
May
2
revised Dynamic monthly excel calendar
added 103 characters in body
May
2
comment Dynamic monthly excel calendar
Nice, but the question was quite particularly about Excel. That means two things: 1. Chances are, the asker has some particular requirement to work in Excel, or is most comfortable using that tool. 2. The asker is probably on a Windows system - maybe Mac. Definitely not Linux.
May
1
revised Dynamic monthly excel calendar
added 100 characters in body
May
1
answered Dynamic monthly excel calendar
May
1
comment Dynamic monthly excel calendar
Ok, that's cheating. :-P
May
1
comment Dynamic monthly excel calendar
A copy or screenshot of your template would be useful. Also describe any existing formulas, and anything you've tried already. Seems like this should be doable, but would be very tricky. Is there any particular reason this needs to be in Excel, and not another application that's more particularly designed to handle calendars?
Apr
23
comment Why can't the VMs in my pen-testing lab ping each other?
I was going to say the problem is using "Host-Only", but the VirtualBox User Guide seems to indicate VMs should be able to talk to each other and the host in this mode. They will not be able to get out to the Internet though. In any case, I usually prefer NAT or Bridged for Internet-enabled VMs and Internal for isolated VMs. I haven't really played with Host-only much.
Apr
21
awarded  Notable Question
Apr
9
awarded  Notable Question
Apr
2
awarded  Notable Question
Apr
1
awarded  Popular Question
Mar
24
awarded  Popular Question
Mar
15
awarded  Popular Question
Mar
11
revised Tracking & Synchronization of Multiple Sheets with a Master Sheet
added 214 characters in body
Mar
11
comment Tracking & Synchronization of Multiple Sheets with a Master Sheet
@agtoever That question appears to only address part of mine, if at all. It only describes how to gather data from multiple sources. This completely misses Step 1. Also, the suggested duplicate only covers "pulling" data from the multiple sheets - there's nothing indicating that the recommended tool can "push" updates from the master.
Mar
10
revised How to turn a “many” row-based relation into a “one” column based layout
edited body