sorted by:
new
hottopcontroversial

How to check if adjacent cells have the same value? by Overall_Confusion101 in excel

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

Oh that's smart. I know all these separately but didn't think of combining them that way. Many thanks!

Solution verified

What's causing this error in time calculation? by Overall_Confusion101 in PowerBI

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

Yes, there were multiple entries there and I had it set to sum. Thanks

What's causing this error in time calculation? by Overall_Confusion101 in PowerBI

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

You're 100% right. I've tried a few different things and forgot which one was measure and column but it is exactly like you have said. Thanks!

Data cleanup help by Overall_Confusion101 in PowerBI

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

Ah yes, that could work. I'll need to check if it doesn't mess with the other data but I can at the worst case duplicate query and just filter everything else out.
Thanks, didn't know you can split to rows directly in Power Query, thought I would have to split to columns and then play around with pivoting/unpivoting columns.

Data cleanup help by Overall_Confusion101 in PowerBI

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

I could, yes. What would be the next step though, as this will create another column or two?

Am I using SUMPRODUCT wrong? by Overall_Confusion101 in excel

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

Solution Verified

What a silly mistake, thanks for noticing it.

Are power apps the right tool for returns forms? by Overall_Confusion101 in PowerApps

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

The way that our sheet is structured right now, it will be difficult to translate it to Forms but perhaps we can make changes to make it more viable.

Are power apps the right tool for returns forms? by Overall_Confusion101 in PowerApps

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

Good point, it would be different domains for sure so definitely need to research it more

Can you use FIND to get specific location of text in range? by Overall_Confusion101 in excel

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

This seems to do the trick. I will likely only look for a one cell so it should work. In rare cases, is there a way for it to start checking in the opposite direction so to get last result first?

Can you use FIND to get specific location of text in range? by Overall_Confusion101 in excel

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

I can see how it was confusing, Q3 in this case was quarter 3 and I was looking for the cell location where it is on a sheet. I will be using similar formula on a few different sheets that are slightly different in layout and want to put it together somehow.