assist

  1. C

    Check Digit

    Trying to do a 10 digit mod 10 check digit with a weight of 7,5,3,2...can you assist me. Thanks.
  2. L

    How to populate a cell[s] by clicking on another cell

    Hi all, 1st post here. I want to cells to populate with "Y" when someone clicks on another cell in a worksheet. Is this possible within excel? If so, could someone assist. Example, someone clicks on cell A1 then cells A2, A3, A4, A5 etc. are populated with Y. Thanks.
  3. E

    IF Formula using 'text' as a condition

    Hi there, Using the IF function, I'm simply looking to return the contents of a cell only if it has text in it. I thought the Logical test might be; IF A1 = " " This is clearly wrong. Can anyone assist please? Also, if the cell is blank (False)then it currently returns a 'zero'. I would...
  4. J

    convert random list to alphabetical A-Z list

    I have a list of stock codes in randomised say A's ( out of order) , then B's etc and want to convert it to a strict A--Z list within each letter in other words, make it a proper A--Z list can some assist please thanks
  5. A

    Stop counting day if another cell is populated

    Hi :) I need help trying to create a formula that will stop counting in B2 once I enter a date in C2 and want B2 to retain the count it stopped at. Currently B2 is =TODAY()-A2 A B C <colgroup><col><col><col></colgroup><tbody> Initial...
  6. S

    Vlookup with IF statement

    Can someone assist...I need excel to perform a vlookup and if the value is less than 100.00 then return 0.00 otherwise return the value in the cell.
  7. J

    Using a Slider with Values between 0.65 & 0.85

    Hello Experts I am trying to use a slider to move between lowest value 0.90 and highest value 0.65. I am so new to excel that i'm still shiny. i know that i need to use a formula but what and how escapes me. Can anyone please assist me with this issue? :confused::confused:
  8. H

    Split Long Code

    I have been trying to set up formula below on 3 line using a _ in between but code changes to red "=IF(ISNUMBER(MATCH(RC[-7],'[BR1 Import Template." & C & ".xlsm]Data Import'!C1,0)),VLOOKUP(RC[-7],'[BR1 Import Template." & C & ".xlsm]Data Import'!C1:C7,7,FALSE),VLOOKUP(RC[-7]+0,'[BR1 Import...
  9. A

    Separate Numbers

    I have a code that prints the 52 week range (i.e. 49.77 - 79.90). I would like to separate the numbers (49.77 & 79.90). I would be using each number in a label. Can someone assist. Thanks
  10. A

    Formula help explanation (search function)

    Hi All I have the following formula =IF(SEARCH("Risk",D41),"x","no") Where there is risk an "x" does appear so the formula is working but where there isn't the word risk instead of getting "no" I get #VALUE . Could any one assist me in getting "no" and explain why the "no" isn't being...
  11. A

    Count and Countif

    I thought count and Countif could use cell references to count how many results were in a particular column or row. example =count(A8,a10,a,11,a15,a22"W"). I have tried the example with count and countif and keep getting error messages. Can anyone assist? Thanks Allie
  12. H

    Power Pivot Formula not working

    I have tried to set up a formula on Sheet4 to compute the Net Value in Col G (it is the value in Col E-Col F eg E2-F2) it would be appreciated if someone could kindly assist me <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF ;border: 1px...
  13. W

    Formula Help

    Hi Please can you assist with the following problem that I have. I am trying to bring back a value based on three scenarios. The current formula I have is quite simple SUMIF($AZ3,BE$2,$BW3) but I would now like to add to this for two further scenarios. I think it would be something like...
  14. D

    Result only if two other cells contain data

    Can aone assist please I have the following formula =IF(D7-C7<0, 1+D7-C7, D7-C7)which produces the result I want in Cell E7. However I do not want anythingshowing in E7 unless there is data in both C7 & D7. Can anyone assist mewith the correct formula to use for this? Thank you.
  15. R

    VBA if filter has no data then

    Hi all, Can someone assist me on the below. > I need to filter the data in column B apart from blanks and delete the entire row. > If no data found while filtering then i need to release the filters and move on to the next subroutine. Please assist me that how to implement If condition in...
  16. B

    Excel formula that assists in looking for sequence

    https://imgur.com/a/5HUdECj Dear Experts, With reference to the attached table, is there any excel formula that could assist to find the 10th number after Number 1 in Column A (which is 14). I would greatly appreciate if you could assist on this. Thank you! Regards, Brian
  17. U

    Count number "0" after last "1"

    Hi, I want to be able to count 0's after the last 1 in my spreadsheet. The number i want counted is listed in my "="-column. Anyone able to assist please? <tbody> A B C D E F G H I J K L M N O P Q R = 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 1...
  18. C

    Ranking with Excel for a Team based on different criteria

    Hi, Please can someone assist, I am trying to create a ranking based on multiple criteria. Each section has been ranked now I would like to see who is leading in terms of a "FINAL RANK" based on all the ranks. please can someone assist me? Please can someone assist with a formula <tbody> MBR...
  19. A

    Combine Subtotal with CountIfs

    I have this vba code below that I'm using to count, but I would like to use subtotal to count the number of visible filtered data. Can someone assist? Thank you kindly. CCP.Caption = WorksheetFunction.CountIfs(Range("D15:D" & LRow), ">=" & "01/01/" & cbYr, Range("D15:D" & LRow), "<=" &...
  20. N

    Quick assist, number extraction

    I have a cell with "42059 Completed QualityReviewed" in it. I just want to extract the number itself to another cell. Any help would be appreciated.

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top