Excel

Select a solution

  • Function for counting data only not formula

    Hello, I cannot find a function that will count only the data being displayed in a cell. I tried CountA but because there is a formula on the blank cells it counts them as well. I have a list of names

  • Locking a formula or function to a cell

    How do I lock a formula or a function to specific cells, so that even after I sort and these cells move to different rows, the formula or function still picks up on those specific cells?

  • Function or Formula to Lookup a Value

    Hi Everyone, I’m trying to find a good way formula or function to review a store row on SHEET A and return a 1 if true or a 0 if false on SHEET B if the particular part is available. I’ve searched and

  • Adding a NOW() function within a IF formula

    Is there any way I can include a NOW() function within my IF formula. Basically in column D I want to know the latest status of each XYZ #. So if I received something new today I want it to say

  • Any function to solve 'n' within the quadratic formula?

    n^2-n(12X+13.6125)+36X^2=0 Does anyone have any suggestions on any Excel's function to solve 'n' within the quadratic formula? Thank everyone very much for any suggestions

12345Forward