1. F

    Calculated measure in Pivot Table

    Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...
  2. A

    If then formula help with multiple rules - need help!

    Hi, I would like to create a drawing tracker sheet which shows if items have been issued or are overdue / days remaining. Thanks in advance! The way I need it to work is... For column E to calculate an overdue date or days remaining with positive / negative numbers in relation to todays date...
  3. R

    Problem with IF statement when using the get application.getfilename()

    Hey everyone! i need some help with my vba, heres my code: "Public Sub importTextFile() Dim textfile As Workbook 'Set textfile = Workbooks.Open("") Dim openFiles As Variant Dim i As Integer openFiles = getFiles() If openFiles = False Then...
  4. R

    Is there a Script for changing colors based on r g b values in other cells

    Hi I am very new to using the script editor, but i need help getting a background color in column 4 based on the rgb values in columns A(r) B(g) and C(b). I would need it to change when those values change. is there any way to do this? here's a screenshot of what my sheets doc looks like.
  5. M

    Formula from PowerBi to PowerPivot

    I have a formula in PowerBi that I would like to use in PowerPivot. Only in PowerPivot, selectedvalue is not available and I think I should use if(hasonevalue)? However, I get the message: In the Switch function, comparing values of type True/False with values of type Number is not supported...
  6. M

    Combine non-blank items in two ranges (unknown number of values) into a new list

    Need help creating a combined list from values in two ranges. All non-blank items in list 1 should be included before adding the non-blank items in list 2. The headings between and after these lists should not be included in the resulting list. The challenge I'm having is that I don't know which...
  7. P

    How to make a graph that change according to current date ?

    I would like to create a simple graph that changes according to the current date. So I have two values that are added in a "Total" cell, lets say for example : B4 = 75 and B5 = 50, so the the "Total" cell would be 125. And the graph I want would show the time evolution of this "Total" value, but...
  8. S

    Next 5 April from any given date in Excel

    Hi All I'm trying to return the next 05 April from any given date, with the cell A11 holding the date. I was using this: =IF(MONTH(A11+1)=4,A11+1,DATE(YEAR(A11)+1,4,5)) Which works fine unless the date I'm using is a month less than 4 (eg jan,feb,march,April) as it will then return to me the 5...
  9. hayleyg123

    Vlookup between two dates, fix ignoring 1st and last of the month

    Hey, newbie here ☺️ I have a sheet where I want to return the job value (Column H) to a certain column depending on it's expected order date (Column T) So I have this for my formula... =IF(AND(T8>$W$2,T8<$W$1),H8,"") However, if the expected order date is on the 1st or last day of the month...
  10. M

    Simple Pivot Table Help Needed!

    Hi, I'm fairly new to excel and I'm looking for a way to create a pivot table that does the following: There are 3 companies, and each company has 3 categories. Each of those categories has a number of impressions associated with it. I want to make a pivot table that sums categories 1 and 2...
  11. R

    Small business owner needs help with excel formula

    For context: Right now I am a small business owner who uses quickbooks. my customers are set up with monthly payment plans that I manually keep track of. my business has grown so it’s hard to keep track of all these customers at this point. SO the columns I have are: customer name, Amount...
  12. X

    Populate multiple comboboxes with the same listfillrange

    So i have multiple comboboxes in a worksheet. Is there a way i can fill all of them with the same listfillrange? The code for that for one combobox would be: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Set col =...
  13. X

    extend a UDF to work in different workbooks

    Okay. So i have copy and pasted a UDF that lets me find the value from the selected cell in a table located in another worksheet. Now what i need is for it to work in a different workbook too. here is the UDF: Function FindValueInTable(MyWorksheetName As String, MyValue As Variant, Optional...
  14. M

    Vlookup to return date from data sheet if between certain date range.

    Hello all, I have a two sheet workspace. Sheet 1 is called Data and sheet 2 is Print Dates. In Sheet 1 I have in multiple columns three sites. Site 1, 2 and 3. Site reference is found in row 3. Columns A4:A80 are dates for Site 1, Columns C4:C80 are dates for Site 2 and Columns E4:E80 are...
  15. B

    Transferring data (client name & treatment) from bookings worksheet to accounts Workbook

    Good Morning, I have 2 workbooks, the 1st gathers data from my booking app to transfer online bookings, on to the bookings sheet (sheet 1) . Example below (PSB); (so when a client books in online, this is what auto populates on the Bookings workbook Sheet 1) These are then arranged in...
  16. H

    Please help with this statement

    I have to complete the following task, but I do not know what formula I have to use, can you please give me a hand? The statement is the following: How Many Spanish calls were handled by team blue during May 2020? See picture below for your reference. Thanks in advance.
  17. HeRoseInThree

    Counting the incidents that occur on a specific day of the week

    I am using =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=1)) to count the incidents that occur on a Sunday and =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=2)) for Monday and so on. They are working great, except for Saturday =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=7)). I am getting a value that is 9000+ higher than...
  18. X

    Formula to return the position of the last occurent character

    The title can be a bit hard to understand. English isnt my native language, so i am sorry. What i meant is this: I have a Cell with a value of, lets say, "1,2,3". Now i want the position of the last comma. In this case it would be the Position 4. How can i search for it with a formula?
  19. Jyggalag

    Making a frontpage in Power BI?

    Dear all, I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :) I currently have the following Dashboard: Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
  20. Jyggalag

    Alphabetically sort list in Excel

    Hi all, I have the following list: Does anybody know how I can sort this alphabetically? :) Kind regards, Jyggalag

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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
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 "".
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.
Go back