# Calculating Full-width Half-max (fwhm)

Jun 27, 2007

calculate the full-width half-max of a peak in data? My chart (gray value vs. pixels) essentially looks like a letter M. What I've tried is finding the max of each peak, dividing that by two, and then using vlookup to find the corresponding pixel values on each side of the peak. But, since vlookup does not work for descending values, I cannot find the half-max value on the right side of each peak.

## Calculating Time And A Half And Double Time (After 40 Hours)

Feb 20, 2009

I'm battling to come up with the formula to calculate time and a half and double time. My boss wants me to show the overtime worked AFTER 40 hours has been worked. I have attached a copy of my spreadsheet.

## Adjust Cells Column Width Without Whole Column Width Changing?

May 24, 2012

Is it possible to adjust a cells' column width without the whole column width changing? EXAMPLE...I'm looking to lock rows 1-41 at certain column widths and change the column width as needed from rows 42 and below.

## Macro Which Run After Every Half Second

May 16, 2014

Macro which run after every Half (1/2) Seconds..

## 1/2 As In A Half But Its Coming Up With The Date

Apr 10, 2009

When I enter 1/2 I want it to stay as a half but when I press enter it automatically changes to the date. How can I stop this?

## Pause For 0.5 Seconds (half A Second)

Jun 3, 2009

I need to pause for 0.5 seconds (half a second). How can I do that. applicatiom.Wait can only be used for whole seconds and a FOR ... NEXT loop is CPU dependant.

## Round To Integer Of Half?

Feb 5, 2012

I would like to round down to interger or half. I would give you some examples:

3.76 to become 3.5
2.48 to become 2
-1.12 to become -1.5
0.05 to become 0

I tried to use round down fucntion but I am not able to have the desired outcome. I thnink the issue is with the second argument of the aforementioned function. How many digits should be indicated? I put 1 but it does not work.

## Split A Cell In Half

Jul 29, 2008

Is there any way I can split a cell in half, so I can put numbers in the left part of the cell, and the right part?

If so, I would I refer to those numbers in my macro?

## Split Cell Reference In Half

Jan 8, 2013

I have two sheets. One containing in cell B2 "1211 - Extra Core Hours" (t_Cost_Centre_data) and then another sheet that displays the data. On the display sheet, there need to be two fields. Event ID and Event Name. The event ID is the "1211" and the name "Extra Core Hours".

My question is, how do I split the reference so that only the ID and name appear in the relevant cell?

Ie Event ID Event Name
1211 Extra Core Hours

Note, the ID's and names will change and they will be multiple.

Formula Help!.xlsx

## Vlookup Only Working Half Way Down Spreadsheet?

Jan 20, 2009

I have a spreadsheet with members details in and I've added a few columns showing:

Col Q: Paid 2008 (blank if No, 1 if Yes)
Col R: Show Paid Yes or No (shows a Yes or a No)
Col S: Date Joined (only entered if new and joined during 2008)
Col Z: Subs owing from 2008 (if existing members and owe last yr's subs)
Col AA: Subs to Pay in 2009 (a standard £35 or pro rata if joined during 2008)
Col AB: Pro Rata (if they joined other than at the beginning of 2008)
Col AC: EA Sub? (based on a yes/no column, to add £5 if yes)
Col AD: Total to Pay for 2009

So the formulae (or data entered) for the above columns are as follows:

Col Q: Paid 2008 - blank if no, 1 if Yes
Col R: Show Paid Yes or No - =IF(Q2=1,"Yes","No")
Col S: Date Joined - a date entered in format d/m/yy
Col Z: Subs owing from 2008 - =IF(R2="no", 35,0)....I want a default 35 in here
Col AA: Subs to Pay in 2009 - =IF(S2="",35,"Pro Rata")....says that if there is no date which indicates they are an existing member, they will pay the standard 35, otherwise they'll be paying a pro rata fee...................

Problem:
It all works fine until a certain row (27 actually) - then I get a VALUE! error which points to the Date Joined field. Now I've tested that value against the vlookup table and it returns the correct data, so why doesn't it do it in my spreadsheet????? I've tried changing the formats on the cells; clearing all data; entering a different date, but from that row in the spreadsheet down to the last row, it simply won't work! I've looked at each formula in each cell on the rows where it is working and the rows where it isn't and I can't see anything different.

What else can I look for? It is SO frustrating as it does what I need it to to do but only for a third of the spreadsheet!!!!

## Convert Date To Half Year

Sep 18, 2012

Trying to take for example, 9/25/2012 and write a formula to make the resulting cell read 2H2012. Or 4/15/2012 and have the resulting cell read 1H2012.

## Printing Cuts Off Half Page?

Jul 5, 2014

When I go to print my 1 page document, I've selected to have the page shrink to fit onto 1 page. For some reason, when I choose this option to shrink, it doesn't print the entire document, only about 3/4 of the page or so. Something I did recently that was a little different that may have caused this but am honestly not sure is i added my company logo to the header so it'd print on the document too. If I added it as an image, for some reason it wouldn't print.

## Half Of Chart Column Is Not Visible

Jul 22, 2007

I have created a combination chart comprising a column and a line. The columns to the extreme right and left are half visible (I can only see half of the column).

Look at my two attachments to see what i mean.
Attachments:
Excel File: http://www.MegaShare.com/235337
Screenshot:
OR
http://img530.imageshack.us/my.php?i...icture1qi7.png

## Half Hour Data Into Hourly Values?

Mar 26, 2013

I have large data sets with half hour values that I need to average into hourly values. Here is an example of the data:

28.12.2012
01:30:00
0,1
2,4
2,5
127,6

28.12.2012
02:00:00
0
0,9
0,9
118,5

[code]....

## Excel 2010 :: Cut Out Half Of Data From A Cell

Sep 11, 2013

Is there a way in excel 2010 to cut out half of the data in a cell .. to make the top four in example to look like the bottom four?

1986 Jun- 9 to Jun-13

1986 Jun- 2 to Jun- 6

1986 May-26 to May-30

1986 May-19 to May-23

1986 May-12

1986 May- 5

1986 Apr-28

1986 Apr-21

## Macro To Format Half Of The Cell With A Different Color

Nov 28, 2008

I have a list of records that will eventually be used to create a pivot table. Sometimes an account number will be listed twice but instead of adding to the previous info, it needs to start a new record. I decided in these instances to mark the account number with a character (+). Even though the + will designate a separate record, I'd like it to be invisible.

Is there a way to automatically turn the font color white for only the +? Since I've automated the rest of the process using a macro, a VBA solution is fine.

## Aggregating Timestamped Data Up To Half Hourly Totals

Feb 21, 2013

I have a worksheet containing one timestamp column and a single column of data, the interval being one minute. How can I aggregate it to get half-hourly totals?

## Split A Column Into 2 - Use Character Limit That Does Not Cut Words In Half

Jun 11, 2013

I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The original column will have a character limit of 30, and should not cut words in half. If the Length will be more than 30 while including the entire last word of the cell, that word should be the first displayed in adjacent cell in the 2nd column.

The 2nd column can be any length.

I usually use a Text to Columns method, but dont know how to make it not cut off the words.

## Excel 2010 :: How To Merge Big Dataset That Is Split In Half

Mar 9, 2014

I am running 2 audits on aspects of patient care. The first audit records a unique number that identifies the patient, and then a series of answers on demographics, and other stuff.

The second audit also records the unique number, and collects some other data on the particular patient at a later point in time (medication usage, levels of pain etc).

So in theory both audits will collect different information on the same patients. In practice, some patients will be missed and there won't be matching data sets. The order of collection won't be the same either, ie Audit 1 might be in the order of Patient 1,2,3,4 etc but Audit 2 might be patient 2,4,1,3

For various reasons these two data collection tools are not linked, and I end up with a spreadsheet for audit 1 and a spreadsheet for audit 2.

I need to merge these so that I can see all of the data for a particular patient at a glance, and where the gaps are, and apply some statistics to it etc. I could sort both lists by the unique audit number so that they are in order, and then copy blocks of data over from one sheet to the next, but there will be records missing, i might make a mistake with the alignment, and I'm sure there must be a better way.

I am using Excel 2010. Each audit case has about 50 columns of data for Audit 1 and 30 columns for Audit 2 . There will be ~20 new records (Rows) created each week that I want to progressively merge.

## Determine Half-Way Point Of Bar Series On Bar Chart/Graph

May 30, 2008

i have created a xlColumnStacked chart using VBA in excel 2000. i would like to place a line in the center of one of the Points(). How can i locate a specific point, for example Points(1), so what i can then "draw" a line in the center

## Automatically Changing Color Of Cell Within Half An Hour Of Inputting

Jan 9, 2013

I want to create a macro or formula for changing the colour of the cell after half an hour of inputting.

## Nested If: Width Of A Shoe

Mar 19, 2009

Column E has several variables D, EW, B, M, W. All of these pertain to a the width of a shoe.

D = Medium
EW = Wide
B = Narrow

## Relationship Between Width And Pixels

Jun 8, 2009

Got two spreadsheets that should be identical, and in both the column widths ARE identical - when you look at the no. of Pixels. However, the other width is different. So what's the relationship between width and pixels? Is this difference to be expected?

## Fixed Column Width

Jul 22, 2009

I'm trying to create a vb to get all columns on my sheet to have a fixed width.
If I run my sub all columns go back to the set width. But I want the width to reset when the width is changed.

## Set Height And Width Of Cells

Aug 31, 2009

I am in desperate need of a macros that sets the heights and widths of columns and rows on a list of provided spreadsheets.

On each of these sheets:

MySheets = Array("FY09 Installation Support", "FY09 Install", "FY09 Purchase", _
"FY09 CF Discretionary Grants", "FY09 CF LOI", "FY08 Purchase", _
"FY08 Installation Support", "FY08 CF Discretionary Grants", _
"FY07 Sup Install Support", "FY07 CF Install Non-LOI", "FY07 Sup Purchase", _
"FY05 CF Carryover Install", "FY04 Recovery Funds", "FY05 Recovery Funds", _
"FY08 Safety Carryover", "FY09 Safety", "FY09 Transport Canada")

I need to set the height of all the rows to 18.00. I need to set the width of all of the columns to 12.00, except for columns A, C, and T, which need to be at a width of 28.00.

## Fixed Width With CONCATENATE

Nov 19, 2008

Excel 2007

I want to CONCATENATE 3 columns

column 1 will have names
Columns 2 and 3 will have numbers
All will be of different lengths

Is there any way to set a fixed width when I use the CONCATENATE funstion so everything looks more uniform (left justified)

## AutoFit Max Width Size?

Feb 22, 2012

I wish to autofit all cells in a database to a maxwidth. ie:

Code:
With Range("A1:F1250")
.MaxWidth = 100px
.AutoFit
End With

## VBA Listbox Column Width?

Jun 5, 2012

I want to fill a listbox with n columns so there is no space other than the text in it.

I have tried this:

listbox1.columncount = 2
listbox1.columnwidth(len(activecell.text);len(activecell.offset(0,1).text))

Or:

mystring = len(activrcell.value) or refer to the excel column width

listbox1.columnwidth(mystring;mystring2)

but I get an error message.

Or max of list len or something. The default width is to big and specifying the length could make it to small.

## Set Blank Columns To Be Certain Width?

Sep 4, 2012

How can i make blank columns be certain width using VBA... I need to do this because the data that is populated in a sheet will be different every time i need the blank columns to be certain width.

## Set A Column Width To Some Integer Like 10?

Dec 17, 2012

I set a column width to some integer like 10, and the next time I open the file it has changed to something like 9.89. Is there some configuration that prevents this from happening and leaves my setting alone?