Hi.
I'm working on a vacation calendar for a group of teams.
I have the data in a table like this:
group
name
location
TeamA
Person1
S
TeamA
Person2
R
TeamA
Person3
P
TeamA
Person4
S
TeamB
Person5
R
TeamB
Person6
P
TeamB
Person7
S
TeamB
Person8
R
TeamB
Person9
P
TeamB...
Hi all,
Long time lurker, first time poster - let me thank you all for years of troubleshooting and learning with pro's how to be a bit better in Excel.
My question is around VBA - not very well versed in it - and will try to explain as best as I can.
I have a list of countries with a score...
Hi guys
I'm trying to put together a countifs statement but am getting a little stuck.
I want the formula to calculate how many blanks are in the corresponding C column, if the value in the B column is 5.
I managed the first condition (to count how many 5s there are in B):
=COUNTIF(B2:B10,5)...
Hello,
New to this forum, I thank you for your help in advance.
I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...
Hey Group
I need some Help to this formula
=IF(And(D9=1;L11=1);D12)
That Part Works Fine
i now need a "Or function after that Working formula so it might look like that perhaps
=IF(And(D9=1;L11=1);D12)or If(And(D9=1;L11=2);D11)
i have try that but it wont Work
and not for any thing i...
Hi. I have a problem that is driving me nuts. Am fairly new to M code but thought trial and error would have solved my problem by now. Upside is I have learned a lot on the way even if I still haven't solved my problem. I have a (text) column called EntryDate with the date of all orders...
I'm trying to calculate a simple AVERAGE based on two source tabs 'Category' and 'Score'. Stipulations:
1) No helper columns on the source tabs; data from source tabs are exports from other systems that must remain untouched
2) Average scores on 'Result' tab should be calculated using a formula...
Hi there,
I´m new in the VBA world and I´m trying to learn how to use it in an efficient way and at the same time develop a feature in my spreadsheet, see bullet 4 below:
#1 Copy an activated row, insert a new row below and paste the formula in column(not formula) there (Solved)
#2 Highlight...
SUMIFS with multiple possibilities for one criteria, can be solved using:
=SUMPRODUCT(SUMIFS(G10:G100,A10:A100,A5,B10:B100,B5,C10:C100,C3:C6))
According to:
https://www.mrexcel.com/board/index.php?threads/821600/
But If I need to apply SUMIFS with multiple possibilities for 2 criterias...
This is my first attempt at building a Userform. It was actually going well and everything was working until I realized that one of my boxes was not posting a result. On the form I have a series of questions with Points awarded based on the answer. For example: It the answer to question 1 is...
I have a data sheet similar to this. I would like to know what I need to do to create formulas/functions that allow this to happen while running an advanced filter.
<tbody>
Rank(5 Star Rating System
Name(Multiple duplicate names)
Tier(Typical letter grade scale)
1
Name1
A
1
Name2
B
2...
Hi there, I have an export from our zendesk helpdesk and am trying to find the average time to solve a ticket. So far, I have tried to sum the Open date and the solved dates, then average the result. that seems to get me the correct answer ( i think!) until the first "solved date" is blank...
Hi,
I want to replicate the search function from excel, but without going to the cell location when there is a value found.
So I started making a search function myself.
It works to the point that I can find a value in a selected cell, which is pointless.
This is my code
Private Sub...
I can't figure out why I'm getting this error only on this one row. All my other formulas on the Revenue Summary sheet work fine.
{=SUMPRODUCT((MONTH(InventoryTracking[Date Sold])='Revenue Summary'!M2)*(InventoryTracking[Sale Price (Before Tax)]))} **no problems with this one**...
I have a tabstrip named ufRooms.tsWoodRun. Trying to disable all other tabs when selecting one so you can't accidentally select another before pressing the enter key. Anyone know if theres a way to do that?
Thanks,
Jordan
Hello,
I have been trying to create a runtime tabstrip unsuccessfully. I have 4 named ranges I need it to populate the tab names from depending on which tab on ufRooms.tsWood is selected. The 4 named ranges are named the same as the 4 tab names on tsWood ie: Doors, Windows, Trim, MiscWood...
Having trouble wrapping my head around condensing this. The blue version is working, the black version is working, but the green is what I'm trying to make happen but not sure how to go about it. It's making "test" a value of zero rather than copying q to test. I get why just not the how to...
Hi everyone
its been awhile since i have been on here to post a question.
so appologise now for this question.
How do i mark my post as solved?
i can not seam to find it anywhere.
Thanks in advance
-Excel 2013
-Windows 7 Professional
I would like my scroll button to hide the same rows in specific Worksheets.
I'm new to VBA so I used the Record Macro trick, however the constant switching the screen does causes the application to freeze. I wrote the code to the point where it hides the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.