Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
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
Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
VBA - Question on Array - Microsoft Community
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 array by only
Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
Sorting names with addresses???? - Microsoft Community
I am trying to create a trifold pamphlet of addresses. I entered the names in 2 columns, address with phone number under it in the 3rd column.....how do I sort the names alphabetically while keeping
Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
=%A1%+%A2% error (when i select a cell automatically excel inserts two ...
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 understanding is correct, I would like to confirm that the problem is observed in every Excel workbook with formulas or only a specific Excel workbook?
Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
remove all numbers or text in a column" - Microsoft Community
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) please help - i can't do it manually the text is varied and the column is over 5000 cells. To get rid of the alphas use this UDF in an adjacent column.
Global web icon
microsoft.com
https://answers.microsoft.com/zh-hans/msoffice/for…
EXCEL2016中没有DATEDIF函数了吗 - Microsoft Community
在使用EXCEL的时候突然发现，之前一个常用的DATEDIF函数无论如何都找不到了，想问问是不是也有和我一样的情况？ 1.按照函数日期与时间类别搜索→没有 2.全部函数搜索，D开头的函数 试着直接输入DATEDIF搜索结果也找不到，是这个函数从Excel2016中消失了吗 ...
Global web icon
microsoft.com
https://answers.microsoft.com/ja-jp/msoffice/forum…
EXCEL for mac (office365) 応答なし - Microsoft コミュニティ
現在office365の環境でのExcelをMacで使用しております。かなり古い形式のexcelデータを開いてから、直近作成したexcelデータをクリックしてもフリーズし「応答なし」の状態になってしまいます。他の質問の回答で出ているアドインのチェックを外すなどしても一向に症状が改善しません。試しに ...
Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
Copying columns of ActiveX Combination boxes alignment problem with ...
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.
Global web icon
microsoft.com
https://answers.microsoft.com/en-us/msoffice/forum…
"Ghost numbers" - Microsoft Community
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 when the columns, which require certain criteria are calculated. Column 5 is a good example. The interface control numbers results would be, in this case, 4,1 (the bottom two rows). The criteria used as the ...
Global web icon
microsoft.com
https://answers.microsoft.com/fr-fr/msoffice/forum…
mémoire insuffisante pour afficher en entier : help!
Excel gère les graphiques d'une façon un peu spéciale. Même si tu as un gd nb de barettes mémoire, la partie dévolue à la gestion des graphiques est toujours limitée. Les graphiques sont particulièrement consommateurs de ressources si tu as laissé la case ajuster la taille de la police.