0.0px

  1. K

    IF(ISNA...) with VLOOKUP on another worksheet to return "M" if not present on other worksheet?

    Hi, everyone, I have two worksheets with a list of students on each one, "lib_checkin" and "lib_hah." Only some of the students on "lib_checkin" are listed on "lib_hah," along with the period that they have a class. If they ARE listed on "lib_hah," I want to return the value of what period...
  2. B

    Appending a Value to Each Element of a Range Array

    I have a workbook with 2 sheets: Sheet1 and Sheet2. In Column A of Sheet1 I have a short uninterrupted list of product IDs: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...
  3. E

    Conditional Formatting for Gantt Chart not working

    I am trying to create a gantt chart in excel using conditional formatting. For some reason, my formulas don't work for every event. I have two colors: dashed gray for uncompleted tasks, and red for completed tasks. The formula for the uncompleted tasks is: <style type="text/css">p.p1 {margin...
  4. M

    Conditional Formatting - change cell colour and and adding text

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}</style>Hi, Im trying to use condition formatting to change the cell colour and add some text to the cell. The formula I’m...
  5. P

    Default Excel row height doing something strange

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}</style>Hope someone can work out what I've done wrong .... In ONE particular file, default row height is misbehaving. COLUMNS A...
  6. M

    How to highlight a cell only if value exist and leave if blank

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}</style>Highlight a cell if cell two rows on the left has x value. If blank do no highlight. Err how would i do this? Thanks, Matt
  7. M

    How can I project sheet formulas whist having a save button on other cells to project them?

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000; min-height: 14.0px}</style> I have a worksheet with columns A1-A10 with a formala which calculate B1-B10 values...
  8. charlesstricklin

    Calculate date given current number of days in advance

    I'm not able to calculate the date (accurately) I should run out of an item using the formula: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #003ecc}span.s2 {color: #005109}</style>=TODAY()+N2 where the values in...
  9. A

    Index Match with multiple lookups?

    Dear MrExcel Users... Please see attached spreadsheet link: https://www.dropbox.com/s/jmuov911ggkwrw9/DeliveryCosts_Example.xlsx?dl=0 <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>The formula I'm looking for help with is as...
  10. A

    Index Match with multiple lookups?

    Dear MrExcel Users... Please see attached spreadsheet link: https://www.dropbox.com/s/jmuov911ggkwrw9/DeliveryCosts_Example.xlsx?dl=0 <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>The formula I'm looking for help with is as...
  11. J

    hel separating

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style> <tbody>...
  12. A

    How to extract Arabic language words from list of different language

    Hi I have a sheet with a column of list of words in different languages I want to get only Arabic words and put them in different row For example: input <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px 'Helvetica Neue'; color: #000000}span.s1 {font-kerning...
  13. S

    Simplify formula? simple math per column, outcome classified by condition & column priority

    Hi there, I have the following formula referencing columns E to J. As you can see, I do some basic math on some cells from a column, and use the leftmost column which fulfills a condition referencing some other cells from the column. <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px...
  14. E

    Extract Range Removing Empty Strings

    Hello Need help. Worked on this formula pieceing together stuff from google. However it doesnt work. It will work if my range is just standard text, but doesnt work with empty strings in the cell. The range I am extracting from is a column list that shows a cell if its >0 otherwise its ""...
  15. I

    Ambiguous name detected: Worksheet_Change

    Below is my macros when i updated on my excel i get this error msg: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px 'Helvetica Neue'; color: #000000 ; color: rgba(0, 0, 0, 0.85)}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px 'Helvetica Neue'; color: #000000 ...
  16. T

    Bulk insert images and want to lock aspect ratio

    Hi, May I know how to lock aspect ratio by editing below code? <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}</style>Sub InsertPicFromFile() Dim xRg As Range Dim xCell As Range Dim xVal As String On Error Resume Next Set xRg =...
  17. M

    Formula = Blank

    I have this formula in my spreadsheet that looks at a value in another worksheet in the workbook and if it is I want it to be blank but it is putting in a zero (0). Can you tell me what might be incorrect? <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida...
  18. S

    Find and Replace Macro

    Hi all, I'm very new to macros so I feel like this is pretty simple, but I just cant get there yet. I have a very large file downloaded to Excel from SPSS. SPSS left behind a lot of #NULL ! in my spreadsheet. Doing a simple CTRL+F and Replace will crash Excel because the file is so large. I...
  19. M

    HELP PLEASE! Determine scorre by look at number that is between two cell values

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>Hi, I would like to use a vlookup to determine the effort scope in column L by referring to the table in...
  20. H

    Formula challenge, need clever help!

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>MrExcel gurus, I'm trying to improve a workbook that helps manage spending well enough that it justifies...

Some videos you may like

This Week's Hot Topics

Top