shown

Ok, Im not sure how best to explain this... so here goes... We are rebuilding our time sheets, and using pivot table to summarize the data. We have our projects, Job #, Labor Code, PW(Prevailing Wage), and then the summary of hours: Reg, OT, DBL, Other & Total... There can be multiple Labor...

I am trying to work out a formula for the following IF Column H = "Y" then the text "Not Rqd" is shown in Column K, however, if Column K = "N" and Column J>Column I then the text "Yes" is shown, however if Column K = N and Column J<Column I then the text "No" is shown. i know this is probably...

Hi Everyone, I need some help in calculating QTD for mutilple years, months and dates, please see the table below. My actual sheet will have data from 2018 to future years by each month. And each month could have multiple dates in it, like shown in the sample data. I would like to display the...

Split numbers in 7 positions and make all possible sets adding 0 in it</SPAN></SPAN> Hello,</SPAN></SPAN> I need to produce all possible set adding 0 in to given numbers (spiting in to 7 positions)</SPAN></SPAN> Which finally sum should be = 7 for each of lines</SPAN></SPAN> Here are the...

<tbody> A B C D E F 1 <tbody> $ Amount </tbody> <tbody> $ Amount </tbody> <tbody> </tbody> Pool $2000 2 <tbody> Paid in auction Bought by non-owner </tbody> <tbody> Paid in auction Bought by owner </tbody> 30% <tbody> 70% </tbody> <tbody> Status </tbody> <tbody>...

Hi, I am using the code at present shown below. The pasted value is £0.00 & in the address bar i see =SUM(C30:D30) which is from the cell that was copied on the original sheet. I tried .PasteSpecial but that kicked up the Run time error 13 type mismatch,strange as when i debug it im shown...

hi, i'm trying to make a formula so that the next quarter, third friday is shown....(ie December 21)

I have a spreadsheet with two workbooks as below Book1BCDEFGHIJKL32Period2016/172017/182018/192019/202020/212021/222022/232023/242024/252025/263301 BuildingCost Summary Book1OVWACAD2Rail YearDeliveryTotal3Sub-totalConstr.Sub-total42019/2036,450.00250,000.00337,500.00373,950.00Business Plan...

Hi, Anyone have any idea why it is I have two up arrows and two down arrows in a form control combobox scrollbar? As shown in image. Thanks in advance!

Please can you advise how to re-arrange the way the msg text is shown. The current code in use is shown below which reads "33 Photo Doesn`t Exist" I would like to have it read "Photo 33 Doesn`t Exist" MsgBox Target.Value & " Photo Doesn't exist! ", vbCritical, "No Photo Found"

Hi, I have the code shown below, Can you advise the correct way to write it because if my value is 4 i actually see 4$0.00 Removing the 0.00 in the code then i see 4$ I cant get it to be shown like $4 Me.txtCost = Sheets("LPM").Cells(i, "E").Value & "$0.00" Thanks

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I want to count the distance between the character "1" and "2", count start should be with "1" and to last "2" </SPAN></SPAN> Data are in columns C:P, and the count results are shown in the columns S:AF</SPAN></SPAN> Note optional request: if...

Hi, How do I write a code to replace cell that contains specific value. For example, when "0.00E+00" is detected, I would like the cell on the left to replace "0.00E+00" <tbody> Column A Column B Row 1 AB 0.00E+00 Row 2 0 8.65E+00 Row 3 EF 0.00E+00 Row 4 0 1.85E+00 </tbody> When...

Hi expertise, I have 5 different values to be used in multiple cells. if cells contain all the value then, Unsatisfactory to be shown. if cells contains all value except unsatisfactory then Inconsistent to be shown. If cells contains all value except Unsatisfactory and Inconsistent then...

When I open a spreadsheet, to which I have got one link to another workbook, I get an error message which tells me that 'another' link cannot be found/opened etc. I have looked in Data/Edit Links and the only link listed is the one that I have put in. No other link is shown. How can I found...

my userform contain 3 textbox TextBox1 value = 1 TextBox2 value = 5 TextBox3 value = 10000 sheet1 range("C2") = 120000 and range C3 formula is = C2*(1+6/100) now formula start from range C3 my problem is i need formula calucate till TextBox2 value ie. 5 menas formula calucate 5 cells C3:C7 if...

Hi - To Simplify My Question A1 - Start Date A2 - End Date A3 - Contains 3rd NOV A4 - Result So In A4 I Want To Return The Result As Follows... If A3 (3rd Nov) Falls On Or Between The Dates Shown In A1 and A2 Then The Result Is "1", If Not Then The Result Is Zero Thanks

Hello everyone, I am working on creating a column chart in excel. I am almost done with the graph and have produced the column chart shown in the first picture below. I would like to modify the chart I have produced so far to look like the graph shown in the second picture (which I created in...

I am currently working on an issue where **=IF(I34>0,IF(SUM(I34,I36)>0,SUM(E38,I38),""),"")** If the number is greater than 15 a number is shown as long as a number is in either E34 and I34 or E34 and I34/I36 Or E34 and I36 I am at a loss of the I36 peice how to get that value shown

Hello, I want to see the result of %45 for the column A numbers base on their value. If the value negative the result will shown as positive If the value is positive the result will shown as negative <colgroup><col><col></colgroup><tbody> -10,000 4,500 </tbody>...