unsolved

I'm missing something in my =countifs and =sumifs...I've gone in circles to the point where I'm going crosseyed. Basically... If Zak Astorg on Sheet 1 has 3+2+7 points, then Zak Astorg on Sheet 2 has 12 total points. What formula would you use to tabulate total points for each person across...

Hi, I have a comment section (N) that everyone put their initials or name in instead of the cell (O) . Is there any way that excel can recognize their identifier ( initials, name etc.) within the cell (N) and then put the initials or name in cell in column (S). I have tried text to columns but...

Hi, looking for a little help on how to improve my next available reference formula to include gaps. The next available ref: AA007 Ref Heading AA001 Test1 AA003 Test2 AA004 Test3 AA006 Test4 At the moment I have code: ="The next available ref...

I'm using the GetURL code to retrieve URLs from hyperlinks: Function GetURL(cell As Range, Optional default_value As Variant) If (cell.Range("A1").Hyperlinks.Count <> 1) Then GetURL = "" Else GetURL = cell.Range("A1").Hyperlinks(1).Address End If End Function...

Hi, I need a formula that will do a distinct count for multiple criteria. I need the Rows to only be counted once if Rows A, B, and C are all distinct. This examples is small but the workbook I have to do this distinct count on is over 36,000 rows. Customer Account number Customer...

Hello world, I have a sheet containing a bunch of PivotTables and graphs. The sheet has an area (B2:F2) where users can input filter criteria which when applied, will automatically filter the graphs displayed to the user. For my data, there are literally tens of thousands of different...

In this image i need to get the stock will reduce from the remaining stock value 28 then ( 28 - 5)= 23, (23-3)= 20, like this for various materials Exact take value of first cell then subtract that from every cell and also i have to apply this formula for all materials. Please help