Forum Widgets
Latest Discussions
Excel jumps to A1 when selecting a range on another sheet during VLOOKUP
Hi everyone, I’m experiencing a strange issue in Excel and I’m hoping someone can help. Steps to reproduce the problem: Open a workbook with at least two sheets (Sheet1 and Sheet2). On Sheet1, start typing a VLOOKUP formula When selecting the table array range, switch to Sheet2 to select the range. Excel unexpectedly jumps the selection or view to cell A1 on Sheet2, losing the intended range selection.YPCOct 24, 2025Copper Contributor29Views0likes1CommentFormula help on IF function
Hi all, I have a very simple if formula, that says if cell v35 contains the word critical, give an answer of 4. =IF(ISNUMBER(SEARCH(“Critical”, V35)), “4”, “1”) How would I extend this to say if it’s critical say 4, high 3, moderate 2, low 1? thanksDanielwood1985Oct 23, 2025Copper Contributor21Views0likes1Commentwhy is excel changing a formula in a locked and protected cell
I have quite a complex spreadsheet for use in my hobby of PBM - the spreadsheet includes an order form for players to submit instructions but with 1 player i am experiencing problems that I cannot fathom why it is happening Upon emailing my spreadsheet, one of the cells in a hidden and protected part of the form keeps changing, the formula changes for no obvious reason creating an error as it is then trying to bring in/read data from an invalid cell. This only happens with this 1 person, everyone else who receives the exact same spreadsheet has no issue, the formula does not change and the spreadsheet works as intended - just not for this one person. the cell is hidden and protected, the sheet is also password protected - it should not be possible for this cell to change but it does. Does anyone know why this might be happening? Both myself and the recipient of the spreadsheet run office 365 so there should be no issue with compatibility. as i say it is happening only to this one person, nobody else, and i do not understand why - looking for ideas on how to resolve this issue!!buzzwack1959Oct 23, 2025Copper Contributor45Views0likes3CommentsDelete cells with 3 consecutive consonants
I submitted a question a little while back asking how to delete cells with exactly 3 consonants. The response I had was a huge help, but now I'm faced with a similar problem: How do I sort words by consecutive consonants? And if that cannot be achieved, how can I instead delete cells from a sheet in which a word has 3 consecutive consonants?RahirosOct 23, 2025Copper Contributor14Views0likes0CommentsCountifs help
im using countifs to keep track of the amount of times my criteria appears in row, but i'm trying to figure out how to make it count by .1 instead of by 1. Any helpw ould be greatly appreciated im slowly learning all the uses for excel.ReeseTOct 23, 2025Occasional Reader49Views0likes2Comments"Getting Name" bug on my worksheet
One of the cells in my worksheet has a "Getting Name" bug on my worksheet - I have no idea what this is referring to - I've never seen this in my 40-years of using Excel - there are no Range Names nor Links in this workbook. What is it and how do I get rid of it?Tahoe24x7Oct 22, 2025Copper Contributor82Views0likes3CommentsPassword for EXCEL document lost
I seem to have lost me password for my EXCEL document. Is there anyway to recover it, or override it? Thanks!ldebivortOct 22, 2025Copper Contributor316Views0likes2Comments
Resources
Tags
- excel43,270 Topics
- Formulas and Functions25,089 Topics
- Macros and VBA6,497 Topics
- office 3656,195 Topics
- Excel on Mac2,686 Topics
- BI & Data Analysis2,430 Topics
- Excel for web1,969 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,670 Topics