Hi,

I need help creating a VLookup function in Excel 2016 for Mac. I have struggled with this problem for years, and I am finally asking for help! ;-)

I need to find the ID for each analytical …

Experts,

I have made a pivot of the attached but I cant seem to manipulate it the way I want.

The raw data is organized as DD Amount ("draw down amount"), DD Date, Repay Amount, Repay Date, …

Hi Experts,

I have recently switched from MS Excel 2013 to 2010 becasue of which formulas like NA, NUMBERVALUE are not working.

Any help how to get the above formulas working into Excel …

I had this question after viewing how can this formula be modified so that it doesn't require control shift enter …

I have column A in sheet1 and Column A in Sheet2

in sheet3 Column A i want to list unique list of all values that exists in Sheet1 ColA and Sheet2 ColA

please see attached.

I had this question after viewing multiple table in one worksheet into one master table using userform …

I have a Power Query from a table. As I am still learning about what Power Query can do I am struggling with Grouping.

What I am trying to do is:

Group by Customer, by level 1, show the …

Hello,

I have a spreadsheet with the below layout:

group1 group2

computer 1 computer 5

computer 2 computer 6

computer 3 computer 4

computer 4 computer 1

..... …

Hello everyone,

I have a large spreadsheet which needs to be broken down into smaller pieces of data. Please see attached for a sample of the spreadsheet, with some fake data.

I need the …

Hey. Please check the this screenshot:

Each row is of a different product that we sell, with the corresponding data. I am trying to also include a picture of each of the products.

So far, I …

I have a formula, for example b1/d20. Now I want to copy that formula to the all the cells below it without changing d20. I want all of my results to divide by d20. I did the ctrl-down and d just keep…

I need a formula that extracts out the name in the url and displays it in each cell like you see in column D in the attached sample file.

Any ideas experts?

Hello,

I have a Excel spreadsheet which has the following layout:

Column A Column B

name1 name3.mydomain.com

name2 name5.mydomain.com

name3 name1.mydomain.com…

I would like to have a calendar that will show days of the week by month and will allow the user to enter data for each date, and show totals.

Good day Experts -

I have an excel sheet which contains the below format (Lets call it "Data")

Column_A Column_B Column_C

AAA 123 ABC1234

AAA …

Hi Experts using excel 2010

I have the following formula in my workbook which works fine for all rows expect 6 row....where it returns #N/A

=INDEX(AC63:AH63,MATCH(REPT("C",255),AC63:AH63))

in…

I would like to format a cell based on a specific date - the cell has a formula in it.

Example: Cell R2 has a formula in it

I would like to have it turn 'red' if it is past '4/15/2017'

I'm trying to get a formula that looks up the date in that column and compares it to a list of holidays. If there's a holiday I want it to report the holiday name. If there isn't a holiday then I …

Hello,

Trying to find a way to convert a list of time values in Zulu to local time. Column B has a list of values 01Z, 02Z, 03Z, etc... down to row 20. I need in Column C and D to convert the …

column C (ActType) has the following items in it: PRDIEM PSNEOT PSNE1 PSCROT PSPR1 PSPR2

I need to fill column K (GL) with the appropriate GL acct #'s: 800100 800110 800200

Based on the…

Experts,

How could I modify Col G formula to return SAIBOR rate as shown on the "Set Libor Saibor" if the Facility is either SAR Procurement (R2) or SAR Wakala (R2) but if not either of those then …

I'm using excel 2016

If I have a column like this:

EmployeeID

1

2

If a Select the cell for the number 2 and then I select Fill, then Series and then set Step value 1.

I chose Rows, Linear…

Hello Everyone,

I am spacing out on a way to do some work. I have a need for looking at an employees work hours based on some information from an event log. Currently I pull various event ID's …

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to do.

I have three formulas that return a result when a dollar amount is input.

I would like to combine the three into ONE formula.

I will need three $ inputs but my formula would return only one comment.…