knowledge

  1. Welsh Mark3

    Highlight Text

    I have a column of notes - lets say this is column A. I want to highlight just part of the the text. In this case it just "#addingvalue" I can use the Conditional formatting function but to my knowledge it highlights the entire cell, I just want to highlight of change color of text just for the...
  2. C

    Tough One? Yes for me, probably NO for you.

    First of all "Thank you" for reading this message and considering some help with my questions. Attached is a department schedule pdf. and I need a spreadsheet done so I could view it with the bar graphs and also a weekly spreadsheet to my weekly dates. My knowledge is best at "novice of excel"...
  3. Shazz

    PRI to show when entering text in a cell

    Hi All, I want to type say 042/18 into any cell in column F and need to to automatically show as PRI042/18, can anyone advise how I go about this please. I have only basic knowledge of Formulas and Codes. Thanks Shazz x
  4. D

    Automatic Dashboards

    Good night, I started interning in an office where my boss asked me the following: "I'm going pass to you the sales KPIs, for you automate the dashboards generation" From what I understand ... the office uses a website to generate various reports in "Excel Binary Sheets". My boss takes...
  5. L

    All possible combinations of 4 from a list of 5

    Hello, I need a formula which produces a list of all possible combinations of 4 numbers using a group of 5 numbers without repetition . For example: If the group were 1 2 3 4 5 I would need to produce a list like this: 1-2-3-4 1-2-4-5 Etc My knowledge of excel is relatively basic, so any help...
  6. M

    Making bold a string starting with selected two letters, last row is missing

    Hi! I know that there are a lot of mistakes, but I would like to solve this problem by using my current knowledge. And it seems to me that there is just one row in my code that is missing... I can't finish it, making bold what i want. Can you help me? Have a nice day https://imgur.com/a/AKIrdM8...
  7. P

    Tasked with making a formula, but I dont have any real excel knowledge

    Alright, here's the problem. I need to make a stock market simulator, but lack a lot of the knowledge of Excel formulas. I need a solution or formula that can be copy pasted and still work the same that takes a random number rolled in Sheet 3, finds the corresponding value on sheet 1, and then...
  8. M

    Help!!

    Hi, I am brand new to this forum and not sure where to post this so forgive me if i did it wrong. I need help with a formula for a rate card for my job. I need Excel to calculate dollar amounts based on footages. The criteria are listed below. I have tried everything I know based on my limited...
  9. S

    How to Auto- message pop-up

    Hi, I'm Selva from Logistics background... i have develop excel format with check-boxes without VB.. if there any possibles to make it with formula... since, i don't have knowledge of VB... Pl help :confused:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top