Hi Thanks so much for looking at this for me.I have column starting with (S2) with both positive and negative number If you can help me with a formula that I could put in T2 that would put a 1 in

Dec 14, 2015 · When using Excel VBA to create macros, is it possible to create a single 3-dimensional array instead of two 2-dimensional arrays then copy a selected range.value into …

Dec 1, 2023 · Hello,I have a lot of data received from a database that customers supply us from a that I need to sort into an easy breakdown. One column is the "Event Name", in which …

May 13, 2014 · Looking at this, there are 7 columns. What I need is a way to find Ghost numbers. A ghost number is a number that works in the interface system but was not designed to, it …

Jun 21, 2013 · i have a column with a list of numbers including text that I don't want. How do I just keep the numbers? I've tried wild chard finds (but can find a wild card equaling any text, or any …

Jun 27, 2022 · As per the description shared, I understand the problem facing at your end i.e., Excel will automatically insert the % symbol beside the cell in the Formula. If my …

Apr 29, 2014 · Copying columns of ActiveX Combination boxes alignment problem with box column and ListRangeFill Linked Column I am creating a data entry sheet using ActiveX …

Jul 3, 2025 · I need to calculate a range of spreadsheets containing a cell with alpha value to get a total of cells with that criteria. i.e. spreadsheet A to G cell E10 with alpha value "P" - what is …

Apr 13, 2024 · Excel排序功能突然不能使用，点击升序或降序排列无反应，重启电脑或新建excel表后仍无法使用，尝试重置excel后仍无法使用。

Dec 1, 2011 · I have a workbook with multiple sheets; they are checklists, and answers are either Yes, No, or Not Applicable. It's coded so that the responses are represented by numbers in a …