“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

- CONDITIONAL FORMATTING
- PIVOT TABLES
- SUMIF
- VLOOKUP
- COUNTIF
- MATCH
- INDEX
- LIVE EXCEL HELP
- ONLINE EXCEL HELP
- EXCEL HELP CHAT
- FREE EXCEL HELP
- EXCEL EXPERT HELP
- IF
- COLUMN
- ROW
- COUNT
- LOOKUP
- AVERAGE
- SUM
- ABS
- BOX AND WHISKER
- PI
- RAND
- CONCATENATE
- IRR
- WORKDAY
- MAX
- SUMPRODUCT
- IF AND
- TEXT
- TIME AND DATE
- RANK
- AVERAGEIF
- PERCENTAGE
- RANGE
- DATA VALIDATION
- ROUND
- TABLES
- SHORTCUT
- DATE SERIES
- MAX AND MIN
- DATABASE
- ENGINEERING
- FINANCIAL
- STATISTICAL
- SMALL
- LARGE
- CHOOSE
- FIND
- SEARCH
- HOW TO

Hello, I'm using Excel as my register system. I can not get the total bar to calculate over $100 dollars.
the formula is in B20 it is =SUM(B2:B19)
if the amount i enter exceeds 99 it cell B20 displays #### instead of a total.
Same thing with cell B22 which is where it should display change.
WHAT DO I DO
Please Help!

Solved by E. J. in 19 mins

Hi I need help for a formula to convert text into columns in excel.
100150!Abacavir Ziagen 20mg/mL 240mL Mixture 240mL!553036!CP use
100151!Abacavir - Lamivudine Kivexa 600mg-300mg Tablet 30!553036!CP use
100152!Abacavir - Lamivudine - Zidovudine Trizivir 300-150-300mg Tablet 60!553036!CP use
100155!Abacavir Ziagen 300mg Tablet 60!553036!CP use
100200!Abciximab Reopro 10mg/5mL Inj 1!550131!CP use
100201!Filter - Sterile Durapore PVDF 0.22 micron For Use with Reopro 33mm Unit 50!556031!CP use
100210!Abatacept Orencia 250mg Inj 1!554006!CP use
100230!Acamprosate Campral 333mg Tablet 180!554231!CP use
100250!Acarbose Glucobay 50mg Tablet 90!550076!CP use
100255!Acarbose Glucobay 100mg Tablet 90!550076!CP use
100831!Acetazolamide Glaumox 500mg Inj 1!555111!CP use
101047!Acetazolamide Diamox 250mg Tablet 100!555111!CP use
101400!Acetone Merck 100mL Solution 1!556031!CP use
101408!Acetone Merck 2.5L Solution 1!556031!CP use
101792!Acetylcholine Miochol E 20mg/2mL Solution 1!555111!CP use
101987!Acetylcysteine OmegaPharm 800mg/4mL (20%) Inhalation 10!555031!CP use
101988!Acetylcysteine DBL 2g/10mL Inj 10!556031!CP use
102100!Acitretin Neotigason 10mg Capsule 100!551051!CP use
102115!Acitretin Neotigason 25mg Capsule 100!551051!CP use
102500!Adalimumab Humira 40mg/0.8mL Prefilled Syr 2!554006!CP use
102503!Adalimumab Humira 40mg/0.8mL Prefilled Syr 6!554006!CP use
102507!Adalimumab cartridge Humira 40mg/0.8mL Pen 6!554006!CP use
102508!Adalimumab Humira 20mg/0.4mL Prefilled Syr 2!554006!CP use
102509!Adalimumab cartridge Humira 40mg/0.8mL Pen 4!554006!CP use
102510!Adalimumab cartridge Humira 40mg/0.8mL Pen 2!554006!CP use

Solved by X. Q. in 17 mins

Hi, I have an excel file with 6 columns. Columns B-F are the columns I need help with. I need HTML inserted in each cell. Then I need all of the cells in each row to be combined in a new cell with each bullet point on a separate line within the cell.
Please Advise
Thanks

Solved by E. J. in 15 mins

Hello, I have weekly data (more than 1000 data points each week) collected that I would like to plot them using excel. I want to know how to add each week data into the same worksheet without having to re-plot the data again and again. I also would like to have the axis label by monthly (for example: Day 1, Day 30, Day 60, etc.) Thank you so much for your help. I'm truly appreciate it.
Sincerely,
Wish I know Excel more.

Solved by K. F. in 14 mins

Dear Expert01,
I couldn't upload the excel binary workbook (.xlsb) here since this did not let me. I was hoping if you can help me figure out how to add more data without losing the format of the previous data already on the worksheet. When i upload data, I made sure that the date column is formatted to MDY but it somehow did not applied when the new data added into the current worksheet. Thank you!

Solved by I. C. in 20 mins

I need help trying to get excel to show the difference between two numbers for an entire spreadsheet. Please Help!!!

Solved by B. H. in 23 mins

Hi I need help with an excel spreadsheet to create a formula to do a certain function

Solved by G. S. in 12 mins

Good Afternoon,
We have set up an excel spreadsheet and are running a Visual Basic formula on our Windows computer but this will not copy over to our Mac.. The formula is shown below.. can you please help with how we can run this formula and make it compatible between both the Mac and Windows computers
Thank you

Solved by E. L. in 19 mins

Hi, I need to translate an excel sheet from spanish to english, as I don't speak the language. Please help

Solved by K. Q. in 15 mins

The data in the Excel spread sheet attached needs to be collected into a table and generate a set of charts and graphs in order to expose a possible trend.
Then Calculate the mean, standard deviation and Z-scores for each set of seven-day data points. i Need help

Solved by Z. H. in 12 mins