# formula

1. ### Formula help, counting unique occurences.

I am looking for a formula that will count unique occurrences that start with W81UTH, ignoring duplicates and blank cells. Also looking for a formula that will count unique occurrences that does NOT start with W81UTH, ignoring duplicates and blank cells. I want to achieve the desired results...
2. ### Need formula to find partial string match in a separate column and return adjacent value

I've found formulas where you can use a "wild card", so to speak, to find a partial string match within another column: =IFERROR(INDEX(E:E,MATCH("*"&C1&"*",D:D,0)),"") For instance, this formula would find "dog" (C1) in "took the dog out" (D3) and return "yesterday" (E2). However my strings...
3. ### Countifs in DAX

Hi Guys, I have some problems with counting ID's that meet 2 conditions but on a different row. Can someone help me out with a formula? See the table below for example. Thanks a lot! ID ID Condition 1 Condition 2 If ID meets condition 1 and 2 then return ID, else return blank 1001...
4. ### Calculate hourly rate when SOME of the records are LESS than an hour?

My formula is Daily Rate / (Total Hours * 24) Worked great until I hit a computation with 53 minutes. Background: job pays \$45, and can take up to 3 hours, but often takes less time. For the first time, the job only took 53 minutes. The formula returns an hourly rate of \$0.08 instead of a...

6. ### Help Request - Nested formulas in a SUMIFS formula

Every month I get a ledger from my property management company detailing what expenses were incurred. Unfortunately, it's not setup to be easily digestible. So, I've decided to parse out the data into something where I can more easily understand it. I'm trying to write a formula which...

Hi everyone, Thank you in advance for your help! <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody> A B 1 10/24/19 =A1+10 2 #b7e1cd[/URL] , align...
8. ### Sum the entire column of named range except the first row

Hi Folks, I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to...
9. ### Sum conditional formatted cells

Hi all, I am trying to sum all of the green cells (see picture @ https://ibb.co/vjVRrBC). Green cells are formatted using a conditional formatting formula rule. The purpose of the formating is to highlight every cells in columns U that I have room for in my budget (C8) starting from the top...
10. ### Conditional Format formula

I would appreciate any help with the following. A1 contains the name of a city say Reading. F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell. So what I need is a CF formula that will check if the first 2...
11. ### Formula to pull values related to a coloured cell

I have 3 cells, each cell has a value, 1, 2, 3 The cell value is related to a score, each score located in another cell, 10, 8, 0 To pick a value, the user has to change the cell colour, for example the user picks the cell with 1 and shades it any colour Then the formula needs to pull in the...
12. ### Including LastRow within a formula

Hi All, I have some code which creates a "score" line within my spreadsheet. I need this formula to change each time I run my macro, as the number of questions it relates to is variable. I have the formula: Range("B" & LastRow + 3).Value =...
13. ### special sort on telephone numbers

hi guys i have a table below. In example a if i do the simple sort function i get result A, But i need to get to result B can anyone help me with this ? Result A Result B <colgroup><col style="mso-width-source:userset;mso-width-alt:3140;width:69pt"...
14. ### Formula to make list shorter

Hi guys, I was wondering if somebody could help me with the following. I have three columns, if somebody dials 93xxxxxxxx numbers the rate wil be charged 0.1575, and if someone dials 9320xxxxx the rate will also be charged0.1575. In this case i want to delete the row with the prefix 9320...
15. ### VBA Challenge! How do i save the fidelity of a VBA Hyperlink?

Hello everyone I would like to thank you all in advance for your kind help, I have a good working knowledge of excel, BUT I am rather new to VBA and I could really use some of your help. So I was able to create a simple formula that looked at cells Sheet2 A8 and B8 to create a hyperlink in C8...
16. ### Slow calculation of calculated column in Power Pivot

Hi, I'm having a performance issue while running the following formula: "=Calculate(sum(lines[CB unit]),Filter(Lines,Lines[Index]<=earlier(Lines[index]))" I'm only iterating over 150K rows, but the calculation times out and never seems to finish. It works fine with 2K rows, but really starts...
17. ### Formula being deleted

I have a spreadsheet that has a table in it with a formula in a hidden column for the table. I have a button to delete the records but if the row is highlighted and delete button pressed on the keyboard, the formula in the hidden column will be deleted. Is there a way I can add some vba code to...
18. ### SUMIF formula for Criteria that is a range

Is there a good sumif formula or a different formula that would be good to use for a range of criteria and the criteria is all different but specific to what totals I what pulled out of a larger listing? Thanks!
19. ### Help Needed Combining Index/Match with Sum across Different Sheets!

Hi All, this is my first time posting here. I have done a lot of google searching but i haven't found exactly the problem to my issue. I have multiple sheets which i want to add across. the rows and columns are not in the same order, therefore, a simple sum across sheets wont work. I want to...
20. ### IF Last month

Hi Guys, I think this is pretty basic, yet I still havent been able to figure it out. I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA. A1 has date B1 has value I wanted formula to capture C1...