resulting

I'm trying to use this formula: REPLACE("S";1;1;"O") To remove the first instance of S only. An example of what the column would look like: <tbody> T O O P P T S S P O T O O </tbody> Sadly, It is necessary that I drag the formula I have down thus resulting in all the...

Hi All, This may not be complex to the power users, but I'm struggling to come up with this formula for B2 and C2. Here is what I'm trying to do: Take the value in A2 (141635858), which is the only known value and convert it from DEC2HEX resulting in 8713108. Then take only the 5 numbers...

Hello All, Novice Here I am trying to use a formula that will assign a value based on the words it finds in the table. I am not sure what I am missing. I want the resulting value 1-5 to appear in the "Raw" column. The table below is the mock up of what I am looking to do. =IF([@Answer]=""...

Hi, I have a SUMIFs statement that works but as it pulls data form an external sheet, erros out if I don't have both sheets open when I update. I rarely use sumprodcuts but followed a guide to convert it and I get a value error. This is my original SumIf and resulting SumProduct. CAn anyone...

Trying to figure out how to highlight a cell in an array, based on the results of an INDEX MATCH function. =IFERROR(INDEX($C$5:$O$23,MATCH(E25,$B$5:$B$23,1),MATCH(E27,$C$4:$O$4,1)),0) I would like the resulting cell highlighted. Can't for the life of me figure it out. Dale

Hi, I have many thousands of records like the below: <tbody> 128K.1381.122.2.A.8.51856273-2753672-113 128K.1459.111.128.A.8.51769315-2753672-113 128K.1459.111.2.A.8.51467685-2753672-113 130E.1456.122.28.A.8.51543816-2060102-1 130E.1456.122.32.T.8.51543816-2060102-1...

I could never get pictures to save. Anyway, I have a table (Table A): https://pasteboard.co/HpTLfSL.png and another table (Table B) https://pasteboard.co/HpTLsxl.png and I want to aggregate (Table B agg): https://pasteboard.co/HpTLGFn.png I can do this in power pivot. But then I want to...

I've got a big forecast model, which takes about 5 secs to calculate. There's a lot of formulae that do SUMIFS with 4-5 parameters and I want to make it more visible what it's doing so other people can use it. is there much difference in referencing the ranges directly, or using dynamic...

Evening all Unsure why the following is resulting in an incorrect value. Cells(1,7).value = application.WorksheetFunction.CountA(Range("B:B")

Dear all, I did a search for this question and found many threads where people asked for questions related random selection of cells, however, none was really helpful for my case. Perhaps because I don't know macros very well. Anyway, here my problem: I have an excel database with 61 rows and...

Trying to use AND OR together. IF(AND(A1=5,B1=10)) OR IF(AND(A1=30,B1=10),A1,"") This obviously doesn't work. The OR is to allow a different choice for A1 but B1 remains the some. A1 is a 10 or 30 and B1 is constant. I need two variables for A1 to agree with B1 resulting in a TRUE

Hi, I know I can use SUMMARIZE to create a grouped and summed table using DAX, but how do I then sort/rank the resulting table? Here's my DAX formula as it stands Aggregated Table = SUMMARIZE( 'Table1,Table1[Column1], "Total", SUM(Table1[Column2]) ) I was hoping to add a function...