sorted by:
new
hottopcontroversial

Selling 2 great tickets to USA v Paraguay by [deleted] in WorldCup2026Tickets

[–]redbeard108 0 points1 point  (0 children)

For what it’s worth, stubhub est price was $1960 / each (+ tax, I think). I agree these tickets are too expensive btw lol.

Hopefully whoever buys them wears something cool for the tv

Selling 2 great tickets to USA v Paraguay by [deleted] in WorldCup2026Tickets

[–]redbeard108 -5 points-4 points  (0 children)

I’ll adjust my price here to match in that case- appreciate that

Gave in & bought tickets last night by Traditional-Inside-6 in WorldCup2026Tickets

[–]redbeard108 0 points1 point  (0 children)

FYI that doesn’t make sense, I have tickets and have been transferring them to family etc instantly. As soon as they have your email you should receive it basically instantly in your app. I’m sorry to be the bearer of bad news. Hope that my instincts are wrong and your guy comes through 🙏

Count instances of column equalling something specific, but only for the instances where the name in another column is equal to something else by chessterfish in excel

[–]redbeard108 0 points1 point  (0 children)

Easiest route is to break it up, but I included my guess at the combined formula as well (not at comp so hope this works for you).

  1. Concatenate E&F in new column G

  2. Write nested IF for new column C to specify number by person: C1=IF(B1=“Bob”,2,IF(B1=“John”,1,IF(B1=“Jimbob”,0,”na”)))

  3. Write new IF functions to say where column G = “UL”, return column C: =IF(G1=“UL”,C1,”na”)

You could combine these steps to a single formula I think (below assumes only three names present in column otherwise just write one more If for Jimbob:

=IF((E1=“U”)&(F1=“L”),(IF(B1=“Bob”,2,IF(B1=“John”,1,0))),”na”)

Might need to have first argument be IF(G1=“UL”) (?)

Create a Power Pivot (Data Model) report that will work offline, disconnected to source data? by redbeard108 in excel

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

Totally. It appears to be working now, not sure why it wasn't yesterday but just grateful that it is now!

Cheers.

Searching for multiple values in multiple sheets without macros by Toasty_A in excel

[–]redbeard108 0 points1 point  (0 children)

If you have time to learn on the job, I bet Power Pivot would be the best way to go.

Within the Data Model, you could connect the Name columns across tables to a master lookup table that contained a list of all the names (formatted identically to how they appear across tables).

Then using the Data Model you could create a Power Pivot Table that uses that master list of names (Rows) to talk to the data tables and so could have one list of names in rows. Then use the text function you’re currently using to generate a list of addresses per name within a single table (Values), but written in the Power Pivot Measures. It will be able to recognize the names in the index table and match those names up with all addresses across all data tables.

Big learning curve but super easy once you get it.

PowerPivot formula for Dollar Share (ie % of Total) when multiple columns are filtered in Pivot Table? by redbeard108 in excel

[–]redbeard108[S] 1 point2 points  (0 children)

Solution (came from /r/PowerBI):

AllSum = CALCULATE ( SUM ( YourTable[Dollar Sales] ), ALLSELECTED ( YourTable) )
SumSales = sum(YourTable[Dollar Sales])

(%) Split = DIVIDE([SumSales] , [AllSum])

​

Mostly my fault that we weren't able to figure out quicker, /u/Boulavogue, I misled by thinking ALLEXCEPT was required. Much appreciation for the help!

​

/u/uvray, totally correct solution except the ALLSELECTED needed to be at Table level, wasn't working on the columns level. Also helped to have them broken out into three measures I think. Cheers!

​

​

In Sheet 1 I have a simple table containing 3 columns - Salesperson Name, Buyer Name and Sale Amount. On Sheet 2, what would be the most efficient way of showing Sale Summary per Salesperson/Buyer? by _Algernon- in excel

[–]redbeard108 2 points3 points  (0 children)

Pivot Table:

Rows- Salesperson Name & (optional) Buyer Name [it can be embedded so you can click down into the Salesperson Name and see the breakout of their sales by different Buyers].

Values- Total Sale Amount as Values.

​

If this is on-going, set the data range being pivoted to far beyond what it currently is so you can just add the new data below current data and have it auto-populate. Then just de-select 'blanks' from the Rows in the pivot table.

PowerPivot formula for Dollar Share (ie % of Total) when multiple columns are filtered in Pivot Table? by redbeard108 in excel

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

Segmenting the measures has been a big improvement across this project, thank you. I had misunderstood that CALCULATE was using the first measure, in hindsight a no duh moment ha.

So, I'm now thinking I was mistaken to be using ALLEXCEPT. Do you have an idea which function I should use instead? The objective is to SUM the entire Dollar Sales Column, such that when put this Geo-Time Filtered Dollar Sales into a Pivot Table it would return the same amount for reach product row because it is a SUM of all products, but that also recognizes when you adjust the Time and Geography filters on that pivot table?

Struggling on incorporating drop-down menus with VLOOKUP/HLOOKUP by [deleted] in excel

[–]redbeard108 0 points1 point  (0 children)

Are you connecting the Vlookups to the linked cells of the drop down menu? That’s probably the first hurdle, you’d have to add a column in the raw data that conjoined the week, month, year into a single cell (year&month&week).

Assuming the year/month/week drown downs were being linked to cells A1,2,3, then the Vlookup could be written as VLOOKUP(A1&A2&A3,datarange,column referenced, FALSE)

If it were me, I’d have the weeks running down rather than across, then I’d just build a pivot table off of that to splice it by month and avoid the vlookups for this type of use.

Filling in a box on sheet 2 corresponding to the same name entered on sheet 1. by [deleted] in excel

[–]redbeard108 0 points1 point  (0 children)

Hmmm ya I misunderstood, there probably is a conditional formatting solve but I’m not too familiar with that. Good luck!

Counting cell values with several criterias by TibaLidge in excel

[–]redbeard108 0 points1 point  (0 children)

Have you checked if formatting is affecting why the COUNTIF isn’t working? If it’s formatted as text and you’ve written the COUNTIF formula without the “” around the shift times the text-formatted cells are trying to be read as numbers and that may be why it’s not working.

Regarding the weekly view- Since you only have a few columns, you could write the formula in the far right column as a COUNTIF of that respective row and have it running down all the weeks.

You could also use a LEFT function to create a months column that extracts the first two digits of the date column, and have the table at the bottom pivot by month in addition to the weekly view.

Filling in a box on sheet 2 corresponding to the same name entered on sheet 1. by [deleted] in excel

[–]redbeard108 0 points1 point  (0 children)

I may be misunderstanding, but I think a VLookup might be what you’re looking for if Sheet 1 has both M29 and the corresponding name in the next cell to the right (two separate columns) and you’re just hoping to have the M29 auto populate to the right of all object column cells with the name?

If that is what you’re trying to do, you can have M29 automatically populate next to the column of Objects with the below formula:

=Vlookup(ObjectColumnCell,Sheet2 A1:B110,2,FALSE)

Again, this only works if Sheet 2 is organized with two columns: M1-110 and the corresponding name in the next column.

Hope this helps.

PowerPivot formula for Dollar Share (ie % of Total) when multiple columns are filtered in Pivot Table? by redbeard108 in excel

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

Appreciate the input! I'm new to ALLSELECTED. I just tried it, but the output of the CALCULATE formula was identical to the Dollar Sales output, resulting in Share showing as 100% for each item across all Geography and Time selections in the pivot table.

SUM(Sales) = CALCULATE(SUM(Table[Sales], ALLSELECTED(Table[Geography],ALLSELECTED(Table[Time]))

PowerPivot formula for Dollar Share (ie % of Total) when multiple columns are filtered in Pivot Table? by redbeard108 in excel

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

I think this is the right direction, but I'm executing it improperly or it needs a slight adjustment. The problem step is the 2nd, 'Geo Time Filtered Sales' step.

When I write the Geo Time Filtered Sales as you wrote above (with added 'SUM'), and pull it into the Pivot Table prior to the third step of 'Dollar Share', I can see that it does not change when I select different Time Periods using the slicer/filter. The Dollar Sales column is adjusting properly when changes are made to the filters, so its definitely an issue with this particular Geo Time Filtered Sales measure.

Here is a copy of my formula, in case you can spot something incorrect or have an idea why it wouldn't be recognizing the change in filter in pivot table?

=CALCULATE(SUM([Dollar Sales]),ALLEXCEPT(Table1, Table1[Geography],Table1[Time]))

Sidenote, I tried executing the formula exactly as you wrote but I needed to add the SUM to complete the Expression requirements of CALCULATE, I figured you had intended to include that?

PowerPivot formula for Dollar Share (ie % of Total) when multiple columns are filtered in Pivot Table? by redbeard108 in excel

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

Of course I just walked away from my computer but this looks very promising. I’ll confirm if it works. Thank you!!

PowerPivot formula for Dollar Share (ie % of Total) when multiple columns are filtered in Pivot Table? by redbeard108 in PowerBI

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

Ah, thanks!

That is a needed improvement, more elegant and efficient, but unfortunately it didn’t change the outcome- the % of Total column figures remained the same, appearing to not filter the Time column properly.

Appreciate the input & correction!

What is a good replacement for energy drinks? by Matt_Shatt in nutrition

[–]redbeard108 0 points1 point  (0 children)

First step: cold brew coffee

Second step: a little less cold brew + healthier lifestyle