values

XREPLACE is a powerful find/replace solution allowing for replacing by any or all of four categories, i.e. value and/or count and/or type and/or length; single or multiple elements within each category; and control over priorities of all categories I developed XREPLACE in response to feedback I...

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...

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...

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...

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...

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...

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...

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'...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...