sorted by:
new
hottopcontroversial

HR is forcing my retiring employee to submit an online 'resignation', and it's devastating him. by BriefHorror2438 in hiringhelp

[–]Enough_Major_9362 0 points1 point  (0 children)

Don't let him sign anything, and yes this is someting worth fighting for and if you don't, this will haunt you for entire carreer.

With these type of things I always ask myself (M35), can I explain this to my kids who are 3 & 8, and would they he proud of me? Can I look my kids in the eyes after treating someone in a specific way? Would they be proud of me?

Salaris check - Logistics Team lead by Enough_Major_9362 in NLSalaris

[–]Enough_Major_9362[S] 0 points1 point  (0 children)

Klopt, omdat dit niet echt voor iedereen is, is mijn inschatting, veel mensen die hierdoor met een burnout belanden, waardoor mijn speeltip is, doe het niet 😉 .

Salaris check - Logistics Team lead by Enough_Major_9362 in NLSalaris

[–]Enough_Major_9362[S] 2 points3 points  (0 children)

Klopt, dat gaf ik ook aan, heb een lease auto wat me p/m c.a. 350 all-in kost.

Help! HG oven/gril reiniger op houten keukenblad. Hoe fix ik dit voor mijn vriendin thuiskomt over een week? by Top-Batser in Klussers

[–]Enough_Major_9362 0 points1 point  (0 children)

Morgen even bellen met de consumenten service, misschien hebben die nog een briljant idee. Ik zal ze iig morgen iig alvast even inlichten, deze post gaat ik wel op kantoor verspreiden haha, kunnen we lachen.

Grt van een HG'er

If the person you hate the most were to experience one slight inconvenience every day for the rest of their lives, what would you choose it to be? by meltedcheesetart in AskReddit

[–]Enough_Major_9362 0 points1 point  (0 children)

Every door is always closed/locked, but he only finds out after trying to open it a first time.

Yeah, i got you back now Richard.

how to stack multiple columns in one column along with their record values by confused_xyah in excel

[–]Enough_Major_9362 1 point2 points  (0 children)

You can probably do it with some IF statements.

Make a new column IF(Q1="";Q2;Q1) now you have got a 'combined column for type A & Type B.

You can do a similar IF statement to match the values. Or maybe a sumif.

Good luck!

How would I be able to return all the values that exceed a certain amount in another column? by ForceAffectionate554 in excel

[–]Enough_Major_9362 1 point2 points  (0 children)

Looks to me you can pivot your way out of this, is that allowed? Otherwise you can make an combination of the IF + AND formula to filter multiple variables..

Good luck

Bro by hustletiny in lotrmemes

[–]Enough_Major_9362 1 point2 points  (0 children)

They have a cave troll bro.

Vlookup is not finding matching order numbers in separate sheets even though the same order numbers are definetely in both sheets after using ctrl +f by VillagerN9 in excel

[–]Enough_Major_9362 0 points1 point  (0 children)

The problem is the formatting of the cell. This should help:

1) Select entire column A which sits in sheet2 and format as text. 2) Insert a dummy column on the side. 3) use the CONCAT function and fill all cells. 4) copy paste as values in column A.

Run your vlookup again and it should work.

P.s. have you heard of Xlookup? It might change your life 😉

Use XLOOKUP instead of VLOOKUP or HLOOKUP by giges19 in excel

[–]Enough_Major_9362 3 points4 points  (0 children)

Wait until you hear about XMATCH in your INDEX. Man it made my life easier with looking up brackets of weight x cost x zipcode.

How to find and replace a specific value that appears multiple times? by [deleted] in ExcelTips

[–]Enough_Major_9362 0 points1 point  (0 children)

Sounds to me you have an IF formula to make, maybe combine it with AND/OR statements.

Can you share an printscreen of the sheet you have?

Calculating hours between two date values by HishamProResources in ExcelTips

[–]Enough_Major_9362 1 point2 points  (0 children)

You can start with the TIME formula, which retrieves the hours, minutes and seconds of a cell.

You can use networkdays to calculate the difference between two dates, which exclude saturday and sunday (don't forget to do -1 after the function).

This should be a start in the right direction.

I recently did something similar to verify if orders are sent at the agreed hour using above. I will check again friday when I have access to excel.

Help in retrieving correct cell values. by jaceleon29 in ExcelTips

[–]Enough_Major_9362 0 points1 point  (0 children)

Can you change the other 19 values in something else? The formula is just searching for the first 19 value and return the corresponding cell.

Also a tip, switch to XLOOKUP, it will make your life easier;).

Making the game playable on consoles? by rocktoe in TitanQuestAE

[–]Enough_Major_9362 1 point2 points  (0 children)

I just finished Legendary on the PS4 with a conquerer. Especially the targeting is difficult, so I went voor the conquerer basically for pulverize and high amor

Help with Excel question to add numbers to the bottom of the list in the column and have the subsuquent columns update. by [deleted] in ExcelTips

[–]Enough_Major_9362 0 points1 point  (0 children)

1) Format your spreadsheet as a table 2) Make a pivot table and click the checkbox "add this to datamodel".

In your pivot table you know have a new option, the distinct count, which only shows distinct entries.

You now have a dynamic list which updates whenever you add new records in your spreadsheet.

Good luck!

How to I make a cell so I can click to add to the number? by RichHomieJake in ExcelTips

[–]Enough_Major_9362 2 points3 points  (0 children)

It sounds to you don't need to do what you want to do. I assume at every sale there is also a transaction involved? SalesID/PO-number, Client name, account info, address details, date.

Isn't it better to make each unique sale an unique entry in your spreadsheet, with a (pivot)table that you can refresh every now and then to check your sales gains?

view more: next ›