glidaar

u/glidaar


r/excel•

Requiring a little help with two formulas and hoping someone can help without the use of powerquery or programming.

Column A employee names Column B sale date Column C sale amount Column D each employee's cumulative sales

We also have a sales target ($15 in example).

Column D and column J are what I'm searching for (Imgur link). Helper columns are fine!

Column D = cumulative sales for each individual, restarting when the employee changes.

Column J = xlookup the date when the sales target was reached for each employee.

I only care about the date where the target was reached. Cumulative sales don't matter. There are thousands of lines of data, each employee has a different number of li

915

r/excel•

Is there a way to make the 'return_array' dynamic in an excel table? I want to look up the term "Apple" in my example for the month of "Mar" so in my formula, I'd need to change the $C:$C to a $D:$D.

I want my formula to do this automatically based on the value typed into the yellow box. The user would should be able to type any date that exists in the table and have results come out in the Xlookup.

Using =CHAR(XMATCH(H5, 1:1)+64), I can get the column number based on a user typed in date in G5.

TIA.

https://preview.redd.it/t6xjqkdy47la1.png?width=705&format=png&auto=webp&v=enabled&s=8c4859fe8a18f52a5e8847b40dd0a7a16219ff7e

15

r/ABraThatFits•

I've just purchased two new bras in my ABTF size, 32DD. The band feels good, the cups too except at the gore. The gore touches my torso at the bottom and floats at the top.

Do I need to go up a cup size? Or is it a shape issue?

Measurements in inches- 32 loose, 31.5 snug, 31 tight, 36 standing, 39 leaning, 35.75 laying down. Calculator said 32DD in UK size

Current bra size - 32DD

Breast shape - protruding, top heavy

Other info - weight lifter with athletic build, no pregnancy or surgery.

28

r/ABraThatFits•

Help! The calculation says I'm wearing the right size (or at least the sister size) and bras have never been comfortable.

Measurements in inches- 32 loose, 31.5 snug, 31 tight, 36 standing, 39 leaning, 35.75 laying down. Calculator said 32DD in UK size

Current bra size - 34D in US size, generally wear Aerie or Victoria Secret

Problems - breasts pop out of the top of most bras and the shoulder straps tend to slip. Found most bras uncomfortable for long periods of time.

Breast shape - average protruding, top heavy

Other info - weight lifter with athletic build, no pregnancy or surgery.

28

r/xxfitness•

So on a whim today I bought a box of Quest Chips. They aren't great which was a disappointment but the macros are excellent. Just don't expect Lay's Chips, sadly it won't happen. =(

915

r/xxfitness•

Hi there two-xer's,

I'm doing the powerlifting program Sheiko and I know which accessory exercises I need to do and how many reps/sets. But what it doesn't help with is the amount of weight to use!

Any ideas?

Example accessory - lunges, french curls, dumbell flies, good mornings, pushups, dips...

Focus on the big three lifts DL, bench, squat.

22


r/xxfitness•

So I've been powerlifting consistently for about 6 months and the guys in my club are recommending I get a few pieces of equipment to compliment my gains (belt, knee sleeves, wrist wraps). I've been really lucky to have stumbled upon a club with World Class powerlifters (won't name for you know... reasons. But the main instigator is a Canadian Masters champion with total lifts of 640kg).

My issue is they are all men with very different body compositions (think +180lbs +5'6") than myself so I can't exactly use their stuff to try before I buy. The other woman is 5'8" and 160lbs so that doesn't work either. I'm 5'3", 118lbs to get an idea of where I'm sitting reference them.

Any hints or tip

1116

r/xxfitness•

Hi xx'ers. I'm about to go onto a forced week off from lifting and exercise (medical requirement, no weights/gardening/anything strenuous). I'm at my goal weight, 5'3"/116lbs, maintenance calories for sedentary lifestyle at 1600/day plus 200 on lifting days and doing strong lifts. Any tips on what to do with the week?

08

r/masseffect•

I feel as though a comic should exist where Shepard and/or the Normandy crew are trying to determine whether or not Garrus is magnetic. Does one such comic exist?

He is built with thallium after-all...

923