$300

  1. Z

    Flip data from horizontal to vertical format for uploading

    Hi, Is it possible to change data format in Excel. My data in excel is as follows: Name of GL GL Code Jan-19 Feb-19 Mar-19 Apr-19......until Dec-19 Salaries 8205 $100 $200 $300 $400 $1200[/PHP][/HTML] Tax...
  2. G

    Formula to consolidate two different columns

    Hi, I am trying to create a formula which looks at two different columns (1 and 2 in this example) and returns the value if there is one in either column 1 or column 2. And if both columns are empty, then leave the cell empty. For example for the first row, the formula would return $205 and...
  3. M

    Create a font based on todays date

    I have a spreadsheet that tracks some things. Column A holds a date, Column B holds a #; And Column C holds a $ amount. I want to change the font of Column C to red if Column A plus Column B is Greater than today. So for example; <tbody> A B C 6/10 10 $100 6/1 10...
  4. A

    Index, if sum, match, vlookup??

    Hi all, I am getting stuck on how and or what may be the best way to navigate this data. I have values for injuries and I want to know how much shoulder injuries cost in 2015 and 2016. Imagine if you will; <tbody> 2015 Type of injury Body Part Nature of injury Total Medical...
  5. J

    Sales Tracker Questions on Combining Figures

    <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>I want to make a formula that changes the value of cars 1-14 to 250 when a person inputs a Vehicle in cell 15. I want the payout to calulate the total as cars get put into the vechicle cells. (Line 1 payout would be 200...

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