All Questions
303
questions
0
votes
1
answer
31
views
Split out numbers in a column
I'm trying to split out the two numbers in the cell into separate columns
I've tried "text to columns", using the delimitator "space" but it removes the second number in each of ...
0
votes
0
answers
26
views
How to increment my columns and make sure I get the formula over other rows in my two different sheets in numbers app on MacBook
I have been working on this data. I got two sheets on my numbers app.
The sheet 2 consists of 9 columns and 514 rows and sheet two consists of 6 columns and 9 rows. I want a formula which can help me ...
0
votes
0
answers
28
views
Error when retrieving large integer value from Active Directory in Excel [VBA]
I am working on a VBA script within Excel to retrieve the expiration time of a LAPS (Local Administrator Password Solution) password from Active Directory. The expiration time is stored as a large ...
0
votes
1
answer
151
views
VBA - Cell format type changed from General to Number when value is displayed
I'm facing an issue for days now, and hoping that someone can help me here.
Basically I'm creating a report of a calculation in a new Excel sheet but when I display the values, the decimal separators ...
0
votes
1
answer
56
views
Extracting groups of numbers from a text string and separate into columns
I have found a script that does this task however it seems slow and does not deal with decimal points. I am using a mac and cannot use regular expressions.
Examples of the data set (quite messy)are ...
0
votes
1
answer
86
views
My WEBI report is sorting numbers from source Excel sheet in a binary style
I'm new to WEBI (self taught at work) and am currently having some trouble. I'm running a report from an Excel spreadsheet, where column A is numbers from 1-49.
It looks fine in the query preview ...
2
votes
1
answer
103
views
Excel: How to check for repeated numbers inside a cell 2
I have an excel spreadsheet with numbers from 0000 to 99999 (4-5 digits)
I am trying to find cells that contain up to 2 repeated digits only
(So for example, printing TRUE if the number is 0022 , 1010 ...
1
vote
0
answers
437
views
Excel Pie chart format value and percent label independently
I want to label a pie chart with the abolute values and a percentage. When I show the values only,
[<1000000]0,00." KB";[<1000000000]0,00.." MB";0,00..." GB" ...
0
votes
0
answers
38
views
Excel custom number format
Excel custom number format:
I would like to use this custom number format for negative values as well.
[>=1000000]$#.##0.."M";[>=1000]$#.##0."K";$#.##0
M: for million
K: for ...
0
votes
1
answer
274
views
Excel Dropdown list generates unique ID number for each value
I have an Excel spreadsheet with two columns.
Column A is filled with the same DropDown list that contains "Archive, Directory, Cloud".
Column B must be filled with ID depending on the value ...
0
votes
3
answers
98
views
How to find formula that zero as duplicate but sequentially as 1 and duplicate zero but not sequentially as 0 in a row?
For example, in first row as 1 and third row as 1 but second row as 0 because the second row
the zero duplicate not sequentially
is there any formula to check this in excel?
0
votes
0
answers
487
views
Excel convert YYYYMMDDhhmmss [14-char text] to Date + Time (fastest way)
Recently, I discovered a very quick way to convert YYYYMMDD [8-digit number starting with the year] to a date, via the "Text to Columns" conversion option in the data tab of MS Excel. It ...
0
votes
1
answer
77
views
Autofill numbers with letter prefixes in excel
How do I autofill in excel when there is a prefix? Here is my code that autofills column A with user input start number and last number. But I want to modify it so that it can handle numbers with ...
2
votes
3
answers
541
views
Converting A Text List to Number List/Array in VBA
I have a list of elements as a string of text in the format below, as an example:
1 2 5to7 9 10to14by2
I am trying in VBA (or base Excel 365 if simpler) to convert the string into the full list of ...
0
votes
3
answers
170
views
Excel - how to find repeating numbers and how to create a new searching range after we have found a match?
I cannot find a good solution to achieve the desired results described on the picture:
Can someone please help me with this?
I have tried googling and also asked from AI, but still haven´t managed to ...