0.0px

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...

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...

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...

<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...

<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...

<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

<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...

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...

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...

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...

<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>...

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...

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...

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 ""...

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 ...

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 =...

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...

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...

<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...

<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...