Explore Office on Experts Exchange

Expert Solutions for Your Tech Problems

OfficeMicrosoft Office

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a nu...

Read more
  • 79K Content
  • 14K Contributors

Expert Spotlight
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

Troubleshooting Solution

How can I convert all displayed blank fields to NULL in Excel?

6

having a hard time with Excel after exporting data from data systems (Tableau, Salesforce), all

Troubleshooting Solution

Pull data from one excel worksheet to another.

3

I have 2 sheets in an excel workbook.  I need to compare the first 2 columns of the CU NEEDED sheet

Troubleshooting Solution

Simplification of Date calculation

10

I have a spreadsheet tracking my working time and pay and am after some assistance making one of my

Troubleshooting Solution

Listing of values based on None condition

2

Dear experts,

Need two sets of formula:

There can be two separate formulae for Col C and D in sheet 2:

Troubleshooting Solution

need downloadable template for data analytics specialist routines during the day

9

I need a template for a daily activity log in Excel with dropdown menus for different choices.

Troubleshooting Solution

Rearranging-an-array-of-data when no record found

1

Rearranging an array of data

(followup of post :

Troubleshooting Solution

Excel Row Count In Access 2016 Doesn't Work.

2

Hi Experts,


I have the following code to obtain the Total Number Of Rows with data in Column A.


When

Troubleshooting Solution

Rearranging an array of data

1

Dear experts,

I have two sections, Section A and B

Section A has data is in a columnar form. This

Troubleshooting Solution

Word: Turning off auto width adjustment

1

I find it painful to edit the Word Doc, where each letter causes the width of the line to change.

Troubleshooting Solution

Select-and-list-items-in-sort-for-two or more columns

5

Dear experts,

 

This post is a follow-up from my earlier post:

Troubleshooting Solution

How to troubleshoot a SYNC issue in a SharePoint in Microsoft Office 365 and Intune environment.

bytjie
1

Hi,


This is a Microsoft 365, SharePoint and Microsoft Intune environment.

This is related to the SYNC

Troubleshooting Solution

Excel date calculation

byTom M
2

In cells b5 through b16 I have entered the desired outcome for my question.

I would like to have a

Troubleshooting Solution

VBA remove filter before copy/paste

byEuro5
3

I use this code to open each excel file and copy to a compile sheet. Sometimes the data is filtered,

Troubleshooting Solution

Selecting the non-empty cell range from three columns

2

Dear experts,

 I need a formula which will return the cell which is non-empty.

Of the three cells,

Troubleshooting Solution

Can not add languagepack in Word (office 2019)

8

Hi Experts,


I tried to install a Dutch language pack on office 2019, but I tried load of things and

Troubleshooting Solution

Find value when it falls between two dates with expanded date range

2

Dear experts,

Need a formula, which can perform the following:

  1. Priority 1- to find the date against a
Troubleshooting Solution

Find value when it falls between two dates

2

Dear experts,

Need a formula, which can find the date against a value with in a date interval

Purpose

Troubleshooting Solution

Concatenate Sheet Name in Excel Formula

8

Hi Experts,


I have an Excel file with many sheets (don't know hoow many). All sheets are named by

Troubleshooting Solution

Select and list items in sort for the same variable with blanks and zero values

1

Dear experts,

 

I need help on two sets of formulae. I have attached a spreadsheet detailing the

Troubleshooting Solution

UnMask my email password

9

Hello Everyone,


I am in need to rescue one of my clients. The ex manager who has been fired setup the

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more