Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Rob Henson
Finance Analyst

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

Troubleshooting Solution

If statement using dates.

byTom M
2

Book2.xlsxPlease see cell n2, I am not sure what is wrong with this I think it has to do with the

…
Troubleshooting Solution

Count Unique Excel Values by Using the SUM and COUNTIF Functions

byLadkisson
1

Hello, 

my existing formula needs to be modified. It works as long as I don't apply filters on my

…
Troubleshooting Solution

Hours and minute formula between two cells

byTom M
1

Hours and minute formula between two cells, I need to get a formula that will give me the hours and

…
Troubleshooting Solution

Need an Excel formula (not array) to return a value if a word in one cell matches another.

byCactus1993
8

Book1.xlsx


I have a list of words in Cells B1:B5. I want to return the value "Yes" if any of these

…
Troubleshooting Solution

Error with linked Excel file on date field.

bybfuchs
13

Hi Experts,

Why do I get in one pc an error when linking to an excel file and field defined as

…
Troubleshooting Solution

Change font size of one part of an excel cell

byJose C
2

i have the following formula in a column in excel


=row()&" D1 RI "&TEXT(COUNTA(A$2:A2)+1,"00000")


how

…
Troubleshooting Solution

Macro code problem

byPeter Chan
9

Hi,

It is having the error

to the line like

Worksheets(List1).Cells(RowID2, 8).Value = Format(Now -

…
Troubleshooting Solution

Convert entire column to number

bybfuchs
16

Hi Experts,

How do I convert the entire column to numbers, when trying to drag down the right corner,

…
Troubleshooting Solution

Rxcrl hours minute formula to days

byTom M
2

Please see the attached what formula would give me the .23 in the exampleBook1.xlsx

Troubleshooting Solution

SharePoint 2019  - Replacing Lists with Imports

byJake S
1

I have a form in SharePoint 2019 (local server)  that does a lookup from a list called "Assignment"

…
Troubleshooting Solution

Format column as a link

bybfuchs
9

Hi Experts,

How do I set a column in Excel containing URL's to act as a link?

See below, this is just

…
Troubleshooting Solution

Move old excel data to another sheet

bymilitary donut
12

Hello,  

I was hoping someone can help me with the code for a macro to do the below:


I have an excel

…
Troubleshooting Solution

Adding a picture from Excel using HTML

byget-ADuser -F ($_.Name -eq "Todd")
11

I need to insert an image in HTML code that I already created for Excel to send a message to all

…
Troubleshooting Solution

Join two schedule tables storing info in different format.

bybfuchs
12

Hi Experts,


I have two tables storing schedule info of patients, one has it in one record per day, as

…
Troubleshooting Solution

Line Spacing in Excel 365

byAPD Toronto
2

Hi Experts,


I need to whip up a quick sheet in Excel, and suddenly tthe line spacing on the address

…
Troubleshooting Solution

Numbers getting converted to scientific notation.

bybfuchs
7

Hi Experts,

I repeatedly keep getting this message when opening Excel, any way to avoid it?

Also I

…
Troubleshooting Solution

My Two Fields of the Clinic Numbers Will Not Join or Detect in VLOOKUP

byRex
5

I am going insane trying to get these two columns from two different tables to either "Join" in

…
Troubleshooting Solution

Excel - Data Validation - required input on a cell

bymmj1
3

I am using data validation in an excel spreadsheet - I have setup one cell with a list where the

…
Troubleshooting Solution

Excel: How do I sort columns by value in aa call?

bycuriouswebster
4

I need to MOVE COLUMNS in order to sort them

based on the value of Row #3, Descending.


Is this

…
Troubleshooting Solution

Convert from a column in Excel to a consecutive list for transfer to SQL Server SSMS

byRUA Volunteer2?
3

The column of code comes from a column of numbers where the formula is applied to it.docxCode to

…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more