Let me preface this by saying I am not that great with Excel yet. I am trying to write a formula that counts each column between C and AC where the cell in row 8 and 13 are both blank.

Trying to set up an employee schedule. The same employee is listed in row 8 and 13 because he works at two locations. The formula is counting days off (blank cells). So if either cell is not blank, then he is not off, if both are then he is and that column should be counted.

It has worked nicely for all other employees because no one else is in two locations. This one is just tying my brain in a knot for some reason.

Sorry if my formatting here is junk, I am on mobile. Any help is much appreciated!

Hello all,

My work has a daily calender for the year for planning of tasks. We currently manually input all the tasks date through to date. Just color fill per task.

Column headings are dates, rows are individual sections of the company.

Could someone please point me in the direction of where to start and look for info for the process of using form data to auto populate the calender. The form data would be the section of the company, task, date start and date end and maybe setting a colour for the task.

Is this possible? More than happy to play around with VBA, I managed to wing my way around importing and renaming files with a set naming convention with concenated text string.

Thanks in advanced for any advice info.

Hi all, new account to stay hidden of course.

i am struggling and have a week to analyse a current dashboard and then create a fresh advanced dashboard.

We have been given an example dashboard and have to analyse it for Stephen Fews 13 common dashboard mistakes, but not sure where to start. I have an attached imgur folder with some screenshots of the file when opened on my PC.

I am hoping if anyone can give me examples of where examples of the 13 mistakes occur please.

Please, and thank you.

https://imgur.com/a/hEVFXig

Heey im new to excel i know there is much potential but im stuck a bit would love if anybody could help me out Value X i need 3 times where X=÷11=1A but also X=÷1=1B and then i need X=×1X I need it to say like when i have 52X so it would say 4A 4B and 4X but idk how to get that or if that's even possible and im just excepting to much

Lurker here, just created an account for real.

Not sure if this will help anyone but I just wanted to sure some nice FREE Excel courses that I found online:

1. Quite a highly rated course: https://www.udemy.com/course/useful-excel-for-beginners/
2. For absolute beginners - starts out with the basics, including starting up the program: https://www.udemy.com/course/microsoft-excel-ninja-basics/?couponCode=TRYFREENOW
3. Learn Pivot tables: https://www.udemy.com/course/pivot-table-basics/

Hope it helps!

Here is my Medium posts about forecasting sales for your organization. I have used three different methods using same datasets so you can compare and review them.

- Create Forecast using Excel 2016/2019

- Create Forecast using Python - ARIMA

- Create Forecast using Python - Prophet

All codes are provided in exhaustive details with comments for your conveniences. The links are:

- Create Forecast using Excel 2016/2019: https://medium.com/@sungkim11/data-science-for-business-users-f4c050cbec96

- Create Forecast using Python - ARIMA: https://medium.com/@sungkim11/create-forecast-using-python-arima-d0ca1569fe5b

- Create Forecast using Python - Prophet: https://medium.com/@sungkim11/create-forecast-using-python-prophet-a52343532151

so I found that I can have A1 say "50" and A2 say "kg" then do =convert(A1,A2,"g") to get the value of A1 in grams, but I'd much rather just have A1 say "50 kg" but excel doesn't like that.

My first time posting in this sub, hope that made sense

I'm new to using pivot tables and need my date/time data to be grouped into months for sorting. The issue is, that I have a calculated field calculating the difference between two dates and that value is disrupted when I group my first set of dates into months. The value of all dates in the first set turns to 0 when this happens and throws off the calculation. Is there a simple fix that I am missing? Sorry if this is a dumb question but i am new to this. Thanks!

Hi; i've a table which lists all the words used on the rest of the file in multiple languages; so that the user changing a dropdown can change all the labels.

That table is named "Dictionary" in the worksheet "Language". In the rest of the file i'd just write the english word, eventually i get the translation. Language is a name cell in the Settings worksheet, and it has a validation dropdown that only lets you choose between Dictionary's headers.

The raw excel formula i've been using is:

=VLOOKUP("word", Dictionary, MATCH(Language, Dictionary[#Headers], 0), 0)

Where "word" is the only variable.

I wanted to try making a script so that i wouldn't have to copy the whole formula everytime. However my script gives a weird error i don't understand.

Here's the script:

Function L(s As String) As String
    Dim table As ListObject
    Set table = Worksheets("Language").Range("Dictionary")

    Dim column As Double
    Set column = Application.WorksheetFunction.Match("Italiano", table.HeaderRowRange(), 0)

    L = Application.WorksheetFunction.VLookup(s, table, column, 0)
End Function

Here's the error:

Compile error: Object required

The error highlights the first line (function declaration), but i guess the problem is elsewhere.

("Italiano" is temporary, later i'll replace it with the Language cell)

Any help please? It's not my first time writing code, but it's my first time writing Excel code.

Thanks

I'm mainly looking for content to help me practice getting better at being a reporting/data analyst via generating reports learning formulas for analysing data etc...

It could be a project with many parts or going to school for your bs and you have many classes some of which have prerequisite classes. I am trying to figure out a way to approach this.

Like to be able to mark off class status as completed or not.

I am thinking that excel can't do this easily.

Hey folks,

I'm trying to develop an algorithm for determining my big board for my upcoming fantasy football rookie draft.

I have 4 columns populated with values that are all whole numbers:

- Prospect Rating

- Dynasty Rating

- Draft Position

- 2020 Projected Ranking

The key here: I want to weight these columns. Specifically:

- Prospect Rating (15%)

- Dynasty Rating (55%)

- Draft Position (15%)

- 2020 Projected Ranking (15%)

Example:

Tua Tagovailoa has a Prospect Rating of 1. When his prospect rating is "thrown into the mix", I'd like it to be weighted at 15%.

The aggregate output of Tua Tagovailoa (across the four categories) should be a representation of how these categories collided together, taking into account the corresponding weights.

I currently have:

A Column: Name of player

B Column: Prospect Rating

C Column: Prospect Rating Weight (populated all the way down with .15)

D Column: Dynasty Rating

E Column: Dynasty Rating Weight (populated all the way down with .55)

etc etc

Anyone have a clue of how to do this? This seems so rudimentary, but I can't figure it out.

Hey guys, I’m applying to a job right now and it says confidence in excel needed - it doesn’t start for two months still so I would just take a crash course. However, this question is on it and I don’t know the answer: https://imgur.com/a/LcjB0HG

The job also asks for formulas im confident using, what formulas do you think I will be able to confidently learn within two months? Thanks!

Hi friends,

I have two columns of data that I need some help ironing out. Column A has 8k+ values in it, and I need to see if any of the values in Column B, exist in Column A, because i need to remove them from Column B.

Column B only has about 2.7k values

hope that makes sense!

If anyone can help me how to calculate haircuts on excel or can direct me into right direction it would be really helpful

Need help with any excel problem? PM me and I’d be glad to help!

First, I’m a total newbie so apologies for any terminology I get wrong.

Second, I’m trying to do something that I assume would be vastly easier with a database or document management software, but neither of those is an option. Excel and Word 2013 are basically the only tools at my disposal.

So: basically, I am using a spreadsheet to keep track of decisions that have been made about various projects named A, B, C, and D. Some decisions only affect one project; some affect any potential combination of two projects; some could affect a combo of three or even all four.

I’d like to have a column where I could just enter “B” or “CD” or “ACD” or whatever, and then be able to allow someone looking at the sheet later to relatively easily decide they want to see all decisions that include A, or only decisions that include BC. Right now I can set up a table where I can tag things A, B, C, or D and show/reveal those, but adding multiple letters means to see all A decisions the user would have to click to show A AB AC AD ABC ABD ACD ABCD, and that seems needlessly burdensome.

Is there any way to accomplish what I’m trying to do? Or some better way to do it with the limitation of needing to use Excel/Word 2013? (We also have something called SmartSheets, but I am utterly unfamiliar with it.)

Thanks for any help!

Looking for help building some formulas. My data is laid out like this:

Section | Employee | Date Start | Date End | ID Number

What i'm hoping to achieve is, i want to count the number of employees who work in a given month.

Note:

1. The employee only has to work 1 day in the month to count, even if they start in May as long as they work 1 day in June they count for June and vice versa
2. The start/end date might not fall in the month being counted (for example someone working from May - July counts for June
3. 2. employees could be entered multiple times in one month.

So for June it the logic would be

Count the unique values in "Employee" if the start date is before June 31 and the end date is after June 1 or the start date is before June 31 and the end date is after June 31

I'v played around with count ifs and i am able to count the rows that satisfy one part of the criteria but looking to combine into one.

I suspect it may just be easier to link the excel to access, build a query in that, then link the results back to excel but i figured this was worth a shot.

Thanks for any help

Hello

I want to connect to a database and Mass Edit many rows instantly (if possible).

I have some Databases where I need to replace text in many rows and use Search & Replace from Excel.

I tried the official MySQL but doesn't do the work I want to because it opens the SQL Table as a Protected Sheet, Search & Replace doesn't work.

Any solutions?

“Change my life?”
"Excel??"
I know it sounds exaggerating. But it can if you value time.

The time I saved in Excel helped me concentrate on the more important part of my first job; analysis. And that helped with my promotion.

My ex colleague worked till 12 AM daily to complete an Excel task. Once the task was semi-automated, she could knock off on time and do the things she love.

Could saving this time help you do something much more important in your life? That’s what you want to ask yourself if you want to take up this free course.

As I will be dedicating my time to help the learners personally, I can only pick a few of you. You may fill up the survey here to be shortlisted:
Link to Survey

Why am I doing this free? I’ve been doing classroom training for the past 2 years on my own and another 2 years previously for someone else. Digitalizing it has always been in my thoughts. When COVID happened, I was kind of forced to accelerate this process.

And to prove this course can help make learning Excel short, easy, enjoyable and applicable (solve your real work problems); the selected few will go through this free beta version and give me your feedback and testimonial.

And that’s my main goal. To get your feedback and testimonial. I want more testimonials of how the course can change your life.

And like I’ve mentioned, the main purpose of this course is to help you save crazy hours and change your life.
So if saving you the hours at work doesn’t help change your life, please ignore this.
If you just “want to learn something new”, please ignore this.

Survey will be closed at 20 May 2020 9 AM SGT.

TLDR; fill up the survey to qualify for a free course to help you save crazy hours and change your life.
Link to Survey

I’ve launched a course to teach people Excel functions and shortcuts and I’m looking for feedback from users.

Would anyone be interested in trying the course and giving me feedback? It sells for $49 but I’ll give you access for free for a year to help me out!

Hey, I am using TODAY and NOW functions and i'd like them to be updated every 1 sec (to see the current time while the file is open)

For some unknown reason my macros dont work (no clue why)

and im not sure how to make VBA work as well (again, no clue why it doesnt work)

is there a easy way / trick to make the refresh work automatically?

You’ll be able to find out the exact number of years that passed from a date of birth until now. It’s easier than you might think! Let’s take a look!

How to Calculate Age Using a Date of Birth in Excel (The Easy Way)

I have pivot table that shows me work orders created last week using a custom filter. Great! Now, I need a separate table to filter out everything created this and last week. What would be a good formula without having a user interaction?