formula

  1. E

    how to separate HTML tables from one cell into multiple cells?

    Hi, I have a complicated situation with an unwieldy amount of data. The situation is I have data from my website in excel, each row is a profile (around 100k profiles), that all biographical data is crammed into one data field (or in this case, a cell, since in Excel) in HTML format. The HTML...
  2. J

    Combined (Possible Nested) Formula

    Hello Fantastic Excel SuperUsers: I always like start off with saying thanks for all the help in the past! I have two formulas I would like to combine. =IFERROR(IF(SEARCH("specific text",cell value,1),other cell value I want to copy,cell value) and a INDEX MATCH formula. Caveat would be...
  3. J

    SUM-IF Formula Issue: Results Not Displaying When Draggin Formula Across & Down

    I am using the following SUMIF formula in my spreadsheet: =SUMIF('2020 CBAT Schedule'!$J:$J,!$A2,'2020 CBAT Schedule'!AX:AX) When I attempt to drag the formula down it displays zeros instead of hours from the corresponding tabfrom which it should be sourcing the information from. The same...
  4. G

    How to lock the TABLE from which I had made the drop down list in excel 2007

    Respected Sir/Madam. I am a basic user. I had made a searchable dropdown list by formula (List, Vlookup, Search & etc.) in the same worksheet. I want to lock the table, from which the dropdown list had created, as nobody can change the DATA on that table. If I protect the sheet by password...
  5. M

    Returning the top 3 occuring text strings in a range

    I am using these 3 formulas to return the #1, #2 and #3 top referral source, in other words the value that appears the most times, 2nd most times and 3rd most times. It has been working perfectly until I today when the #2 and #3 happened to appear the same number of times. The result is that the...
  6. M

    Table, extract content from a row, remove blanks and order in order A-Z

    Dear Forum, I am not new to Excel but until now didn't use it in a sophisticated way. I am stuck with a Table, where I am not able to get to my target. What am I trying to do is the following in: As you can see in the below picture, I did some experimenting before going back to my table and...
  7. G

    Count consecutive negative numbers

    I am looking for a formula or vba, whichever is easier, where if the value in the row is negative, it will count until the next 0 or positive number, for the whole column. An example is below. I searched and couldn't find the exact thing I was looking for. Any help will be greatly appreciated...
  8. H

    GetPivotData formula in PowerPivot Help

    Hi there, I changed my standard PivotTable to a PowerPivot, and now I cannot get my head around the GETPIVOTDATA formula. i want to make a reference to a cell containing the date. It gives me a REF error. But if I precede the date with a single quote (H17 = '5/17/2020), then the formula gives...
  9. F

    problem with VBA that checks a true false value in a cell from another xlsm file

    Hi All I have two files : A and B. I am writing a VBA in file A that generates some value and writes that in a cell in file B. in file B macro, there is a Function F and there is a cell in which a formula written that used this function F that generates a True or False value based on the...
  10. E

    Product If Formula for Two Columns based on Current Month

    Hello, I'm struggling to write the formula that would multiply two cells in two different columns based on one of the columns having a header that matches my reference cell. Below is a basic outline of what I'm trying to do. My reference cell is D1 with a formula that returns the current month...
  11. Saher Naji

    Auto-Fill values (2)

    Hello O great and smart people actually I posted a similar thread before some days, and Mr. @alansidman graciously did a great help and his code is working very well, 100% and this is the post link for the solved problem: https://www.mrexcel.com/board/threads/auto-fill-values.1133259/page-2...
  12. E

    Combining Sum and Max formulas

    In columns B and C we have the time and number of cars passing. The objective: find the max total of the sum of 7 consecutives numbers At present we have to split out the sum of 7 consecutive numbers (column G7-10) from data and then max those in G16. Is there a way to combine this to deliver...
  13. D

    Medical Procedure Database

    Please excuse any wrong terms I may use when attempting to ask my question - I'm new to the community :) My goal is to set up an excel spreadsheet that can serve as a database from where I can pull information, in any combination, to perform research, evaluate procedures, etc. Many of these...
  14. H

    Update VLOOKUP result each time the pivot table is changed

    Hi everyone, my VLOOKUP formula in the Sheet1 is getting the value from the pivot table in the other sheet. The slicers from pivot table are located in the Sheet1. I'd like the content of the cell with the VLOOKUP formula to change each time the pivot table displaying different value (for...
  15. Saher Naji

    Auto-Fill values

    Hello Thanks in advance, I tried to crate a formula, but the problem I have to make the formulas fixed by $ symbol, this will cost me a long time What I'm looking for is a formula or a macro to do this thing automatically each time, because I have hundreds of rows, and the number of boxes...
  16. T

    Help on formula

    Need help on what formula to use to calculate the tenure of an employee from hire date in one cell and have that cell tenure count change once I put the resignation date of the employee in another cell
  17. B

    Transposing Data By Matching Criteria

    Hi All, I am attempting to take a table like this: and transposing the "Loss Used" amounts so they are transposed to give each "Loss Year" row a horizontal breakout of when these amounts were actually used. The output should look something like below: Right Now those are static linked...
  18. M

    Last Modified UDF Row Function

    I do not know if this is possible however, what I am looking for is to modify this UDF function to show the date that a cell was last modified. Currently, it is only showing the date that the UDF is inserted, not the actual date that the cell was modified. For Example: -If I am insert the...
  19. C

    Can I somehow Trace Dependents that are in a chart?

    The MS page says that formulae in an embedded chart is not used for tracing dependents. But I find that, even with a non-embedded chart, plotted variables are not traced. Is this to be expected? It seems that a chart is not a formula! Is there a work-around??
  20. M

    VBA Macro: How to reference LastColumn variable in a simple formula

    GOAL: I have a report that will grow by one column of data each day. Each day, I need to add a formula into the first empty column that will find the difference between the value in the last column and another fixed column that will never change. PROBLEM: I have successfully set my variable...

Some videos you may like

This Week's Hot Topics

Top