1. X

    Conditional Formatting question

    Hello everyone, I can't figure out how to accomplish following task: I would like to use conditional formatting to color certain cells based on how big is the difference when comparing two cells above each other. Looking at the example below, Row 2 is the starting value and Row 3 is one that...
  2. D

    TOROW function

    I'm using the TOROW function to transpose my array into one row and it works exactly as I need. The problem is that I need to values now in each cell and not the formula. Copy/Paste as values isn't working, it only pastes the first cell. Any ideas on how to solve? I'm transposing 100 rows with...
  3. R

    Random value must be unique depending on date range

    Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...
  4. T

    Power Query: Import Values only From Table

    Hi all, Is there any way to import values only from a table, rather than formulas? My current code is: = Excel.CurrentWorkbook(){[Name="Table1"]}[Content] How would I rewrite this to bring in all calculated formulas as hard-coded values? The issue is this: I have two tables I'm importing...
  5. Chris_010101

    Paste Values in VBA

    Hi All, The following code moves data to an archive sheet, based on the value selected from a list in column P. It also looks to see if filters have been applied and ensures the data is moved to the next available row, regardless of filtered data. It works perfectly, however, I'd like the...
  6. D

    Sum cells offset from another

    Hi, I'm looking for a formula that can look through a worksheet, find a value and add together the cells next to it. In essence I have a sheet that could have a value eg Oranges a number of times anywhere on it. What I would like to be able to do is have a formula that looks for all the...
  7. S

    How to filter a measure

    I just cannot work out how to do this so any help would be appreciated. I have an account table (dim table): account name, start date, end date. The user chooses a year using a disconnected 'year' slicer. A measure [account status] calculates whether the account is 'active' or 'inactive'...
  8. subby

    Excel formmula to determine which range of value a certain number falls between

    Hi All, I need to figure out how to avoid nested IF-s because I have to determine if the value of cell A1 falls between one of the 20-ish ranges of values, and and return a value based on the result So the cell A1 can contain any integer between 0 and 375 the ranges for which I have to...
  9. R

    Replacing cell contents with the lookup value of that cell

    I'm at a point where i'm bringing in two columns with values (city and county) and i've got a lookup sheet where the value of the state - Say Michigan (or MI) is 45 for example and the county is 13. I'm inputting MI in to the cell but would like for it to somehow reflect 45. I'm wondering if i...
  10. R

    Extra subroutine to crop values of one column to 10 characters

    Hi, I have this macro (see below - code scripting credited to member rlv01) and I would like to add a subroutine which crops all the values of column O to 10 characters only. So I want to only keep the first 10 characters of the data in every cell of the single column O. For example: if the...
  11. J

    Pivot: Double click value in a single cell showing all data

    Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278) Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows When using a Pivot table in 365, if I attempt to double click a cell to show the records behind...
  12. D

    SUMX iterate over smaller table using VALUES

    Hello, just to note I meant to put VALUES not RELATED in the title, but posted and edit won't let me change it. (edit: changed for you :)) Just a question regarding what's actually happening,; I have a formula ; Over...
  13. D

    Power Bi report view

    Hi, Can someone explain why I can't see a 'values' in the report view visualization area , I have x axis etc. but can't see where to drag the values to ? I've added this as thought it might help, yes I have scrolled down . Richard.
  14. S

    Find any nth values from list that can sumup to a value not greater than that cell

    Hi, to every one. I am creating a report. i have a list of different numbers in range M4:M21 What i need is to sum up any 3 or 4 values that can near to 240 but not more than that For Example I have This List Range M4 to M21 57 81 87 50 85 66 70 72 81 54 82 59 86 53...
  15. H

    Index/Match values for multiple possible matches

    I have a list of employees and their course assignments, a list of employees and their certifications, and a list of the required certifications for each course. I am trying to run a single cell check on whether the person is appropriately certified for a assignment based on the range of...
  16. C

    SUMIFS and #values!

    Hi All, I have a really dumb question that I can't seem to figure out. I have a SUMIFS formula searching a range of numbers that contain a few #values! errors. Obviously, the SUMIFS result is going to be an error (#values!) for these, and I can't use aggregate since it doesn't have SUMIFS. The...
  17. S

    Group By Character Name and list all Scene numbers

    Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...
  18. M

    Return a unique numbers of sales list, values as categorized smallest to largest.

    Hi, Required a formula help for generate a unique numbers of sales list as a sequence to be smallest to largest unique numbers without blanks as based on data contains in column A:G. Sample are enclosed, Thanks for help, ABCDEFGHI1Total Sales Units21015101410Return unique numbes...
  19. A

    show values from one workbook in another workbook

    Hi folks, I was wondering if there's a way to get values (with a filter or find function) to show up in a workbook, by looking the values up from another workbook. the left photo (workbook 1) contains all the values and workbook 2 needs to show the values with offsets to the name and article...
  20. M

    Required a formula to return combined a list, common values in a both list, values not included in each other List.

    Hi, Required a formula help for do a different types of workouts as based on data (Work items list-1 & 2) contains in Column A to C, for there required details as follows. In a Column E, Cell number E4 to be return a Combined work items lists (merged list) of both lists into one list, Sort A...

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