1px;

I created a scatter chart of some data and the equation returned was: <tbody> <tbody> y = 7E-24x[SUP]12.666 </tbody> <style>table { }.font5 { color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri...

Hello, Is it possible to work with gaps.There must be a gap of 8 days between visits throughout the year.Can I do this automatically?Location X must be scheduled every 8 days for a visit, starting on 2 JanuaryI do not succeed with macrosWho can help me dave

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> 0down votefavorite My first post here, maybe someone will be able to help. I have a large Excel table with data from labs. Some results are below LOD And I need to remove...

Hi, I have a list of values where i want to use a formula to fill the last column (Q) with the corresponding value q1, q2, q3 or q4 that is defined in the second table. Can anyone help out with the correct formula to do this? thx in advance list <tbody> name value Q text1 99 q1 text2...

Hi all, I have performance data for multiple employees spread across multiple sheets (one sheet for each day of the month). I am trying to get monthly totals for each column. The employee name is not always in the same row in all sheets and might not be present at all. Example of what each...

dear mr excel i have problem in one cell lets say G1 i have value <tbody> 106.97259485721588,-6.261230615140504 106.97383940219879,-6.261321266258494 106.97372138500214,-6.2627076931611905 106.97363018989563,-6.263576874303437 106.97224080562592,-6.263475558784672...

Hi Hope someone can help me please I have a spreadsheet full of data that is not totalled. I cant think of a way to do it. In total I need about 1500 totals so it will take a long time to do manually. See example below Each mini table of data has multiple lines (rows between them)...

Hi All I am having difficulties with creating a formula to deal with the following:- I am trying to autoincrement the last character (1, 2 or 3 characters) of a text string. The problem is the string could be different lengths and needs to autoincrement from whatever the last number is from...

Hi, I have in cell A5 : 02 06 10 25 39 and would like to separate those numbers into 1 cell each like below starting from cell B5:F5. 02 06 10 25 39 = 2 6 10 25 39 Thank you <tbody> </tbody>

If the cell B is blank, then enter the data from A. If cell B is NOT blank, then skip. Column A Column B <tbody> State1 State 2 MI MI OH if this is blank, enter data from A2 KY if this row is blank, enter data from A3 WV WV IN if this row is...

Dear All, <tbody> Lot Price Individual Price Item Size $50 formula goes here<formula goes="" here=""><insert formula=""></insert></formula> Product A 1kg $75 formula goes here<formula goes="" here=""><insert formula=""></insert></formula> Product B 5kg $100 formula goes here<formula...

I need help in removing periods from a series of cells. Example: <colgroup><col style="mso-width-source:userset;mso-width-alt:8618;width:202pt" width="202"> </colgroup><tbody> Columbia-Barnard......................... Duke...

Hi Everyone, VBA noob here (and new to this forum) I m looking for a particular VBA vlookup that seeks multiple values in one cell separated by a comma (name of the product eg. FHGH, RDSD, etc), in another file In this last one, we have: the values to find are in each single row, but they´re...

The following table shows the date of the week and beneath each day is the hours that have been spent on a project, each row of numbers a new the project/job (not shown here). How can I get this into the table similarly setup to the right - with the same headings, using some sort of VBA...

Hi,I want to create different sizes of rectangles with inputs. Then I want to optimally place these dimensions in a specific area (ex: 80cmx160cm). I using method that start with biggest rectangle following firstly go bottom after move left if possible. Actually this method the same with tetris...

Hi everyone, I am having trouble aligning multiple columns. For instance, I have this: <tbody> 12 15 a 15 17 b 17 10 c 16 12 d 10 16 e </tbody> And I need to keep the values in the second and third columns together but align the duplicates in columns 1 and 2 like this: <tbody> 12...

<tbody> Im stuck trying to find simple formula to calculate derivative within a tree code. Lets say for instance: M M1 M2 M11 M12 M111 M121 M122 M1111 M11111 M11112 M11 & M12 derivative from M1 & MM121 & M122 derivative from M12 & M1 & MM11111 & M11112 derivative from M1111 ; M111 ; M11 ; M1...

I have a sheet set up like such: <tbody> Item No. Purch Date Cost Item 1 1/18/2016 12.4 Item 1 2/1/2016 11.12 Item 2 3/22/2016 43.2 Item 2 4/18/2016 55 Item 3 4/22/2016 100 Item 3 5/13/2016 125 Item 3 6/17/2016 300 </tbody> It goes on and on for 20,000 rows. What I...

Hi there, I have to sheets on excel SHEET 1 <tbody> name ID Employee JOHN 5456456456 FRED 141541546 JANE 13131531 </tbody> Sheet 2 <tbody> ID Employee 5456456456 B123123 141541546 B565413 13131531 B54546 </tbody> What I need is a formula to have the Employee number...

Hello, thanks for considering helping me with this. I have this function: =IF(OR(A2={"-1",-2}),5,IF(AND(A2>10),X2*0.9,IF(AND(10>=A2>=3),A2-1,IF(AND(3>A2),((A2-1)/2*0.1667+0.5)*A2)))) Some of the parts are just there because I don't know how to correctly trim down a function someone helped me...