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

Jan 31, 2012 · The table below shows the results of those 2 formula for the numbers 1 to 20. Columns 2 and 3 are the 2 formula discussed above. Column 4 is the 2 formula multiplied together Column 5 is …

Aug 11, 2010 · Hi there! I have a largish worksheet with over 6500 rows. It is a list of all the duplicate files on one of our servers. Col_A is the group number of these duplicates file-clusters assigned by the

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 customers can pick …

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 number) …

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 shows up …

Jul 3, 2025 · When viewed in Excel it shows like this, 2.68435E+17 The only way I can get Excel to display the number even close is to format it as text. I need to upload this data into another program …

Jul 23, 2010 · The first IF condition is just a check to see if we are at the boundary between category numbers. If we are then we check to make sure it is not a nul field and then append the variable …

为什么在将 Excel 工作簿中的一个工作表，移动或复制到另一个工作簿中时，会出现这样的提示：Excel 无法将工作表插入到目标工作簿中，因为目标工作簿的行数和列数比源工作簿少， 若要将数据移动 …

Aug 20, 2024 · My problem is having to change my formula in column D after every news event. I can drag cell D2 down as far as D8 but then have to change it in D10 after the news event. Can the …