I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

Do employees get discounts on buying apple Macs in amex?

Im a contractor. Another firm has reached out for 100% remote work for basically a lateral move. I really like where I’m at right now. I’m remote but if I turn to FTE which is very possible later this year I would probably end up having to go in 1 or 2 days a week to NYC. My manager knows this is basically a dealbreaker for me. Should I let my manager know I have another firm reaching out but I really want to stay but I’d need to be a remote FTE? They mentioned several times I’m an asset.

I have never seen an engagement team do SO much work on planning analytics. This is insanity.

Did anyone watch the series by Sasha Barron Cohen called Who is America? It came out over a year ago. Worth a watch for anyone who can take a joke

Trump sounds like he created 10 million jobs. Moron, people are going back to jobs they had prior to Covid.

Can someone tell Pence to ANSWER THE DSMN QUESTIONS!!!!!

Can we agree the Hunter laptop story, true or not, isn’t going to change anyone’s vote, and just move on?

Does IB require (realistically) a Top 25 MBA? Or will just having a regionally accredited MBA suffice?

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

Hi fellow dog lovers - Sorry to bring up this topic🙈 but just realized I have no idea how to handle the inevitable. My fur baby is 16 yrs old (small breed) and in great health but is noticeably aging. I am thinking ahead even though I don't want to. Is there any unique way to bury a pet? I have never had a pet this long or had one pass so I am not sure what I would do. I was thinking of burying in the back yard but I know we may move in the next year or so. How have you lovingly said goodbye?

Can a company clawback a sign on bonus from you, even if they place you on a 3 month unpaid leave of absence and you find another job during the unpaid leave? Seems like you could claim an invol

when you get the vaccine are you good for life? Or do we have to get these every year like the flu shot?

Do people really get offended when people do not say “good morning! Or Hi! Or Bye?” Is this the pandemic etiquette that no matter what, on phone, busy, interrupt any and all with “GOOD MORNING! HI! BYE!”

How do people make it on the Forbes 40 under 40 list? Do you have to be a multimillionaire entrepreneur?

I love watching my 3-year-old's engineering hacks... he wanted to pet the cat so he built a fort out of pillows and waited, now the cat's purring on his lap and they're both asleep

Hi people. I have availed enhanced health insurance coverage offered by EY GDS.

Some amount was cut under 'Insurance Deduction' in April and nothing in May and June. In July and August, they have deducted amount under 'Insurance Topup Deduction' and some amount under 'Insurance Deduction Others' with no explanation whatsoever! No tax exemption is also provided for senior citizens.

Any idea folks? Also, whom should we reach out to for such queries?

Currently in risk advisory but would like to get into valuation. Has anyone else done this transition and any tips?

What are the side hustles/gigs you are doing? Were you able to get a job into your side hustle without any experience?

I have a column of numbers with a “Special” format. I need these to be a date but when I select the date option from the drop down in the number dialog box it returns as all hashtags. I tried date value, substitute functions etc but nothing seems to work. Any suggestions?

need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

How would I create a bar graph that shows same store sales growth for 5 products that were promoted during different time periods?

What are your favorite excel macros to make you more efficient at work?

Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yesterday I opened it and it’s just all hidden instead of grouped. Any ideas how to fix?

Does anyone use XLOOKUP over Index Match? Why /why not?

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)