
Need to identify positive number and negative numbers in column
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
Forming a breakdown of information from a list of entries
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 …
VBA - Question on Array - Microsoft Community
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 the 3-dimensional …
remove all numbers or text in a column" - Microsoft Community
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) …
EXCEL2016中没有DATEDIF函数了吗 - Microsoft Community
在使用EXCEL的时候突然发现,之前一个常用的DATEDIF函数无论如何都找不到了,想问问是不是也有和我一样的情况? 1.按照函数日期与时间类别搜索→没有 2.全部函数搜索,D开头的函数 试着直接 …
Book keeping and/or expense keeping recommendation
Apr 25, 2022 · In pivot tables, each column and its header will become a criteria that can be used to produce a report. If your data is not arranged in meaningful columns then even pivot table will be of …
Formatting long numbers to display correctly - Microsoft Community
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 …
Copying columns of ActiveX Combination boxes alignment problem …
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 Combination boxes.
"Ghost numbers" - Microsoft Community
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 …
为什么EXCEL表格里面没有内容,但显示文件很大 - Microsoft Q&A
锁定的问题。此问题已从 Microsoft 支持社区迁移。 你可投票决定它是否有用,但不能添加评论或回复,也不能关注问题 ...