QUESTION : The following excel sheet has to be rearranged from ID Name1 Name2 Name3 1 Alf Bert Fritz 2 […]

# Category: Ms-Excel

## VBA – How to apply loop in this situation (Userform.Combox…)?

QUESTION : I tried “For i=1” etc… but not working, I just don’t know the syntax. Could you help me […]

## Excel – Combine 2 sheets into 1 based on person ID and creating new rows if ID is found more than once

QUESTION : I have person data and address data in 2 different sheets which I wish to combine into 1. […]

## How to create Excel comments that by default have no author?

QUESTION : When adding an Excel comment, it is not difficult to remove the “Author:” prefix. But I find myself […]

## Pivot Table: group by date and show the date for each row listed

QUESTION : I’m able to group by date and then all the rows are, as expected, grouped by date. What […]

## SUM condition on one set of columns where another includes certain values

QUESTION : I have the following data in Excel where I want a formula that will give me the sum […]

## Simple Array Formula in Excel not comparing the right values

QUESTION : I’m trying to calculate with an Array Formula (in Cell D2) what i’m calculating in cell D11. The […]

## Excel Formula: trouble with the low % values not showing up in an in-cell chart? (image included)

QUESTION : I’ve a few tables that have % values like -4.5%; -16%; 15%; 6%; 2.5%. I’m interested in creating […]

## excel grid to columns

QUESTION : I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 […]

## Secondary horizontal axis in MS Excel scatter plot

QUESTION : Is there a way to introduce a secondary horizontal axis into an MS Excel scatter plot chart? I’m […]