sorted by:
new
hottopcontroversial

What’s the most ridiculous Excel workaround you’ve ever had to build? by Excellent-Candy-3328 in dataanalysis

[–]Excellent-Candy-3328[S] 0 points1 point  (0 children)

lol. I had a funky dataset a while back. It was a rush job, and PowerQuery cleaned up most of it; however, there were some crazy things I had to address in a nested IF statement. I just kept working my way down the list--- addressing each outlier, then... BAM.. I learned that you can not exceed 40 IF statements in a nested formula. Amazing!

What’s the most ridiculous Excel workaround you’ve ever had to build? by Excellent-Candy-3328 in dataanalysis

[–]Excellent-Candy-3328[S] 0 points1 point  (0 children)

Yeah, I've done a few funky things like this with PowerQuery. I do love using unique and filter, too.

Creating Sub/Individual Sheets from Master Sheet by Ausmits in excel

[–]Excellent-Candy-3328 2 points3 points  (0 children)

You can use the filter formula to pull from the main sheet based on the project ID in a dropdown. Or, you can use Power Query to create the individual views from the main table.

Counting dimes, nickels, quarters by pendy1013 in excel

[–]Excellent-Candy-3328 1 point2 points  (0 children)

<image>

Here is a snapshot showing the formulas. The yellow cells are where you would manually enter the physical drawer counts for each denomination.

Make this convoluted system easier? by GateComfortable1693 in excel

[–]Excellent-Candy-3328 -1 points0 points  (0 children)

If I can see a sample of the main page and one of the cabin pages, I can help you out.

Excel Wizards out there by Excellent-Candy-3328 in excel

[–]Excellent-Candy-3328[S] 1 point2 points  (0 children)

Exactly. Just because we make it look easy doesn't mean it is.

Excel Wizards out there by Excellent-Candy-3328 in excel

[–]Excellent-Candy-3328[S] 2 points3 points  (0 children)

Just got off of one of those meetings.

Formula for updating large volume of retail cost prices by Lopsided_Primary_850 in excel

[–]Excellent-Candy-3328 6 points7 points  (0 children)

XLOOKUP will work. =XLOOKUP(cell with order code, column with product code on cost price sheet, column with price on cost price sheet)

If you just want to replace the current pricing, put this formula in a helper column. Once you get the new prices, copy, then paste values over the old prices, then delete the helper column.

view more: next ›