EN VI
Tag thumbnail
Excel
0 Posts
29 Questions
Posts (0)
Questions (29)
Avatar
Best Solution Bot
2024-03-13 19:00:08
How to convert a text with data in series having field name on left to a table in Excel?
Try this formula: in cell E1 =VSTACK(TRANSPOSE(A1:A3),WRAPROWS(B1:B9,3))
Tags: excel,  text,  ms-office
Avatar
Best Solution Bot
2024-03-14 03:00:05
Excel - How to insert blank rows between data using dynamic array formula?
You could try using EXPAND() function: =TOCOL(EXPAND(A1:A5,,2,"")) Or, =TOCOL(EXPAND(A1:A5,,MAX(A1:A5)/2,""))
Tags: excel,  excel-formula,  dynamic-arrays
Avatar
Best Solution Bot
2024-03-14 10:30:06
How to create Excel Pivot Table from a table with hierarchical columns?
There are many of ways of achieving the desired outputs these days, if you are using Modern Versions of Excel, one such way is using Power Query or Newer Excel Functions, which makes it relatively eas...
Tags: excel,  pivot-table,  excel-pivot
Avatar
Best Solution Bot
2024-03-14 20:30:05
age groups excel: can not find the proper function?
In my case it works by using this : =IF(AND(A2>=17, A2=50, A2
Tags: excel
Avatar
Best Solution Bot
2024-03-15 06:00:06
Excel - Program loops through routine one extra time (Return without Gosub)?
You are falling into the "subroutine". You need the following code adjustment: Do While Cells(EndValueCell, 3) > 0 EndValueCell = EndValueCell + 1 Loop GoSub EndTime Exit Sub ' 0 EndValueC...
Tags: excel,  vba
Avatar
Best Solution Bot
2024-03-15 06:30:04
Excel - How to identify String verities over known categories by Scripting dictionary?
Use two Dictionary objects to track the Provision of customers Microsoft documentation: Range.Resize property (Excel) Application.Union method (Excel) Option Explicit Sub Demo() Dim oDicBAD...
Tags: excel,  vba,  dictionary
Avatar
Best Solution Bot
2024-03-15 16:00:05
Excel Conditional Formatting for cells that re equal to 0 formats also blank cells?
You can use this formula for the red part: =(D1=0)*(D1"") It returns true if the cell isn't empty and the value = 0. (Btw: like this the condition is international ... you could use AND or ISNUMERIC...
Tags: excel,  excel-formula,  conditional-formatting
Avatar
Best Solution Bot
2024-03-15 20:00:07
excel filename by vba script causes 2 filenames?
The file of the first SaveAs seems to have two 2023 which is according to you is wrong, this is because the file path also includes another 2023 and missing a \ behind the 2023 I strongly believe. FI...
Tags: excel,  vba,  filenames
Avatar
Best Solution Bot
2024-03-15 22:30:04
Excel cell validation set by vba sets incorrect data range?
Lock the row references using $: Formula1:="=" & ws1.Name & "!" & "A$1:A$" & aantalrijen2 Or just make the whole reference absolute: Formula1:="=" & ws1.Name & "!" & "$A$1:$A$" & aantalrijen2
Tags: excel,  vba,  validation
Avatar
Best Solution Bot
2024-03-16 00:00:07
Excel - Trying to get names from a box on the right to automatically appear in another box when a different box has a value in it?
Well, if I have understood correctly, the following formula should work as per the given conditions: • Formula used in cell C21 =LET(_Data, C3:C19,_Names, $J3:$J7,FILTER(_Names,1-ISNA(XMATCH(TEXTBEF...
Tags: excel,  excel-formula,  formula
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login