How do you create a lagged time series in excel? Lag of order 1 and 2

like
Posting as :
works at
You are currently posting as works at

Not sure what you are trying to do. But try the offset function? Just need to move the relative position of the cell by how many lags you need.

like

Related Posts

Has anyone put notice in at a firm and accepted a counteroffer to stay?

like

Feeling more and more burnt out and unmotivated after status calls for my big client because I feel like work gets added every single time and it just keeps piling up. Anyone else feel this way?

likefunny

Essential non-work desk items?

like

Going to Jamaica in December. Please share some recommendations for where to stay, activities, places to visit, where to eat, etc.

like

Hi folks i work at bellandur and wanna live in the apartment with my family. Please suggest me nearby areas.

like

I honestly apologize because I know this kinda thread shows up a lot but I’m honestly looking for advice on if I should stop putting money into savings.

28, M
Checking: $10K
HYSA: $35K
Brokerage: $8K
Retirement: $70K

Kinda late to the game on investing due to lack of knowledge and paying off student loans. No debt, pay off cc every month. Own a home, so have mortgage. Should I use the money I put into an HYSA and go direct to my brokerage? I tend to be conservative that’s why I like more cash

like

Anyone know who to contact at Adweek or Adage about a campaign that may warrant coverage?

like

Hello! Is anyone looking to hire a new PM? Please DM me if so.

like

What is the Salary bracket for AM?

like

I work as Business Analyst, but now I am looking ahead for a package of 18lakhs, holding an experience of 4.5years. Will any company provide me with it?? I stay in Bangalore!

like

I was working at a Hotel one night & I saw a man appearing on two different floors, then in the stairwell. The man was in his 70’s or 80’s. He was wearing nothing but tidy whiteys. When he got to the front desk I asked “is everything alright? Are you okay?” (Assuming he may be senile),He wasn’t senile, he went swimming & wanted to make me uncomfortable and started to flirt while in his sopping wet see through tidy whiteys- and of course I had to clean up the water he tracked through the lobby.

like

What interest rates are you all getting quoted for private loans? I did leveredge and it looks like the best I’m getting is 3.67% variable from commonbond

like

Guys need help-
I got an email from Genpact about English Voice Assessment. Is this round conducted for all analytical roles as well?

Has anyone given this English Assessment round?

Hii Guyz,
Please help me if there's any opportunity as travel manager or travel desk in of MNCs

Location:Hyderabad or Chennai

like

Does anyone have any remote opening for Salesforce Administrator position

like

Let’s talk diversity. Do you think the industry is doing a good job in attracting and hiring under-represented minorities? Do you really believe diversity is important to our stakeholders?

likehelpful

What are the advantages and disadvantages of working as an immigration attorney for a nonprofit?

Hi, I am currently working with TCS but looking to switch. I have experience of 7 years in the fields of customer service and sap data processing, worked on live chat platform and back end data processing. Any leads will be helpful. I am open to night shifts and looking to move to ITIS or IT domain

like

When people ask you for YOE, do you include your time in grad school at all? I feel like writing that you have 2 YOE when you’re 30 years old gives a warped sense of level and compensation.

like

Need to figure out someone’s phone number. Any ideas on how to do it? (obviously looking to figure this out without asking the person)

Additional Posts in Excel Genius

How do I convert a google doc link to excel?

likesmart

Any macro experts that can help changing this 3 generation family tree generator to a 6 generation one (template link provided in comment below)? Provided by Microsoft but I have no idea how to edit this macro to allow more generations, and this is the easiest to generate template I've seen unfortunately

like

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

New to Fishbowl, would love some likes! Or you can comment with your favorite IF statement in Excel. (Long formulas encouraged!) 😉

like

Q. Is it possible to turn off track changes on a shared excel document ? I looked it up and it saying, “Press review” and I can disable from “Track Changes.” However on the document I’m using, I press review and I only have the option to “show changes.” Anyone know a way around this. Trying to at least remove the history due to a micromanaging manager

like

Any ideas for how to reshape a dataset from wide (panel) format with two column header rows to long (pivot) format while keeping one column header row?

Post Photo
like

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

Noob here:(
Lead wants me to limit values in 5 columns - achieved
Now she wants me to implement - If 1st column is filled and others' are empty, raise an error. Tried ISBLANK but it removes drop-down

like

Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?

like

Having trouble with data dependent drop down list. In sheet 1 I have “type” and “subtype” columns that are blank and I need column B to be a data dependent drop down of A. The master data is the format:
(A.) (B)
T1 S1
T1. S2
T1. S3
T2 S4
T2 S5

How can I have my list show only S1-3 if I type in T1 in column A? (T1 = type 1, S1 = subtype 1) there are multiple words, spaces, and numbers for the data as well

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Workaround for a median ifs formula? I’m assuming an array but cant nail it

Any books to learn advanced excel?

like

Hey. Is there a situation where only an XOR function could be used? Or even generally where is the XOR function used?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

I’ve Paid 3 ppl who couldn’t do this for me on Fiver. I run a football Tournament. The last number is the Total points. How do I set this up where it moves it moves up or down automatically

like

Is there any way to generate a summary of comments or view all comment for a workbook?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal