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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top