# assist

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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.