I'm trying to sum column B if column A is not equal to "Text1" or "Text2" or "Text3".
I cant seem to get a sumif to work with or, it's driving me crazy lol
u/Fapper_Keeper
I'm trying to sum column B if column A is not equal to "Text1" or "Text2" or "Text3".
I cant seem to get a sumif to work with or, it's driving me crazy lol
Title says it all.
I used a mustard based rub not long ago for a pork shoulder and I loved it, so I'm trying to do something similar with ribs.
I need some suggestions!
i inherited a report and i'm trying to make a chart with drop downs, so maybe a pivot chart?
it looks like this. Notice that column C goes back multiple years.
so what im trying to do here is have chart with a drop down that contains the items in column B, then have the 2020 weeks displayed on the X axis, and i want the values in the chart to be the YOY (2019 to 2020, from column C) % change, by week, for that item. like this
im fine rebuilding a data set in a separate tab or whatever then adding to it every week, but i cant change the format of the original data set.
if any one can help id appreciate it, i hope i was clear an
im trying to populate a range of cells based on pivot table data, but with two criteria (week and UPC). ill try to explain this the best i can.
i have a range with dates in the first column, and UPCs across the top; i have a pivot table formatted the same way.
what im trying to do is populate the range based on the pivot data, ie- if week 1/5/19 shows X units for UPC 123456 in the pivot table, i want that value to populate for week 1/5/19 UPC 123456 in the range.
it seems so simple but its driving me crazy lol
I just pulled my brisket at 205, but plans changed and I need to keep it hot til 6ish, so i kept it wrapped in foil then wrapped it in towel, and now it's sitting in a cooler.
My questions:
Should I drain the foil?
How long will it stay warm?
So the treadmill made the power go out as soon as my gf turned it on, I went to flip the breaker but no breaker had tripped.
There is a GFCI outlet on the same circuit that doesn't appear to be getting power (the reset and test buttons don't work, no light comes on, nothing turns on when plugged in).
I don't know where to go from here.
Is it possible the treadmill fried the GFCI outlet and that's what's preventing the power from coming back on?
We had the treadmill plugged in elsewhere and it would cause the breaker to trip occasionally; where it was before had no GFCI outlet. We just moved it yesterday and now this.
I'll do the best to describe what Im.trying to do, but i'm on mobile so bear with me.
Say I have data similar to this:
Michigan primary: 10% Michigan remaining: 15% Illinois primary: 12% Illinois remaining: 13% Ohio primary: 8% Ohio remaining: 9%
How can I make a bar chart that groups together Michigan primary and remaining, then a space, then Illinois primary and remaining, then a space, then Ohio primary and remaining?
This is possible in excel so it's gotta be possible in Power BI...
With all the attention it's been getting I looked into it, it looks like a less populated Hawaii. It's beautiful.
Is it worth making a vacation out of?
I'm building a report that has two main tabs, sales and units, and there are buttons on each of these main tabs that take you to bookmarks of expanded views for each data set (not drill throughs, it just takes you a visual that's easier to look at).
So my question is:
Is there anyway to make the back button on a tab take you back to a specific tab? In this case, one of the main tabs (sales or units)?
If not, what's the best way to accomplish this?
I know work will be getting done soon in terms of resurfacing the trail, but does anyone know it's current state? Is it crushed limestone or just a double track the whole way?
kind of a weird sub-genre to be asking about, i know, but after reading The Descent and the Dark Eden series it got me really interesting in stories that take place in completely dark environments.
unfortunately i don't even know how to begin looking for this sort of thing lol
anyone have any suggestions?
i'm trying to clear out any rows that contain the word "total," but "total" appears across many columns.
as it stands I'm using the below code, just modified to go through each column (6 in total), and it takes forever.
how can I speed this up? there has to be a much better way than how i'm doing it...
Sub test()
lastrow = Cells(Rows.Count, "G").End(xlUp).Row
For i = lastrow To 1 Step -1
If Range("G" & i).Value = "Total" Then
Range("G" & i).EntireRow.Delete
End If
Next i
For i = lastrow To 1 Step -1
If Range("F" & i).Value = "Total" Then
Range("F" & i).EntireRow.Delete
End If
Next i
sub
and i basically cop
below is the code. it does not work at the moment.
what i am trying to do here is have a loop start on the last row of data, move up the data row by row, and delete any rows that contain a cell in column L that start with "I/O".
so there is a couple things here i'm unclear about. the first being how can i use the left function to determine if the cell starts with "I/O"? is this even possible? i've bolded the suspect portion below, it is currently wrong.
the second is can the looprow variable even equal 'Cells(Rows.Count, 1).End(xlUp).Row', or does that not work? i didn't get an error in module, but i'm still not sure.
thanks for any help!
Sub CleanIOitems()
Dim looprow As Long