post

  1. 6StringJazzer

    Two new threads do not show entire page, do not allow responses, do not allow likes, reports

    There are a couple of new threads that display only the post text but nothing below it. These are duplicates of each other, but I can't report them: https://www.mrexcel.com/forum/excel-questions/1087738-get-value-column-put-column-b.html...
  2. A

    Cannot post the body of my question, it only posts the first two lines

    I have tried to post a question with a couple of lines of example, but it only posts the first couple of lines -why?
  3. S

    Copying entire rows from multiple sheets based on criteria

    Hello all, this is my first post. Sorry if I violate any norms or post a question previously answered. I have multiple worksheets in a workbook that contains tenant information for apartment buildings. On those worksheets, I note a status for each tenant (occupied, vacant, or notice). I would...
  4. J

    highlight cells closest to zero and 1.600 in columns, and apply to all rows

    i need help with the following: Highlight the cell that contains the number closest to zero in the "-1.6" columns Highlight the cell that contains the number closest to 1.600 in the "+/-%" columns Highlight the cell that corresponds to the closest number to 1.600 in the "POST C276 +/-%" columns...
  5. D

    Dividing a cell based on another cell

    <tbody> I am trying to write a formula to calculate cost per foot (cell E13) I want the total in cell E12 to be divided by cell C8 if it has data if not move to cell C9, do this through C11. Item Quantity Cost Total Corner post assembly 8 90 720 "H" assembly 10 56 560 Wood...
  6. N

    Time Function help with formula needed

    I need help with a formula in Row 53 column F I have time at 0:30 In Row 57 column B I have time at 23:10 in Row 57 column E I have result which is comp3 the formula I am using works for all times from 01:00 to 23:00 but post midnight it doesn't work this is what I am using in cell 57...
  7. N

    Time Function help with formula needed

    I need help with a formula in Row 53 column F I have time at 0:30 In Row 57 column B I have time at 23:10 in Row 57 column E I have result which is comp3 the formula I am using works for all times from 01:00 to 23:00 but post midnight it doesn't work this is what I am using in cell 57...
  8. N

    Time Function help with formula needed

    I need help with a formula in Row 53 column F I have time at 0:30 In Row 57 column B I have time at 23:10 in Row 57 column E I have result which is comp3 the formula I am using works for all times from 01:00 to 23:00 but post midnight it doesn't work this is what I am using in cell 57...
  9. F

    Sum forumla, sum 2 cells then copy down

    Hi, Need help to write a formula which can add 2 cells then divide the sum and post in twice, and also add the next row of cells +1 cell step down. There is probably an easy solution, just dont see it atm .. :/ I'll post a pic of what I mean. Appreciate any help with this :)
  10. A

    How to post a "thank you"

    Hi there! I would like to post a "thank you" but can't figure out how to do it. Many thanks, Jerry
  11. G

    Date

    How do I get date to post in column C and stay as that date when I post something is column B?
  12. G

    Matching column data

    I have a need to match data from one column to another and then post in a third column (received) Using a scanner to read a barcode to post in the second column. Want the number posted to look at column one and find the matching number and then reach to a hidden cell to pick up the (Received)...
  13. N

    Time Function help with formula needed

    I need help with a formula in Row 53 column F I have time at 0:30 In Row 57 column B I have time at 23:10 in Row 57 column E I have result which is comp3 the formula I am using works for all times from 01:00 to 23:00 but post midnight it doesn't work this is what I am using in cell 57 (F)...
  14. E

    Help

    Hi can you say what I did wrong here I want to say if the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25% thanks tks Abidh (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)
  15. L

    copying a table from this form to excel

    Hi I was reading another post in this form and that post has a table like the one below. So I tried it to copy that table from this form to excel. but did not work, they all ended up in one cell. How can I copy a table from here (this form, like the one below) to excel? is that possible? Thank...
  16. J

    Auto-Save

    I just spent about 30 mins on a post and when I went to submit it I got a message saying I had been logged out and had to log in again. As a result, I lost my post. >> Why did it log me out !!!
  17. D

    Reply did not appear underneath post

    In the Excel Questions forum I replied to a post, thanking that individual for a solution, but my reply appeared under someone else’s post later in the thread. When the cursor hovered over the Edit button at the bottom of my reply, it said “Edit/Delete”, but when I clicked it, I did not see an...
  18. etaf

    how to post examples in mac

    how to post examples using excel 365 for mac jeanie doesn't seem to have an add-in that i can work
  19. N

    Post does not appear

    Hi,Today morning I create a new thread and post my problem with the VBA code.But unfortunately it does not appear in MrExcel forum and also when I checked my latest post option it displays me an old post.And I tried to post it a several times.How do I solve this?
  20. F

    Is it possible to calculate the Number of work days that are left in a year?

    This is similar, but slightly different from the last post. I believed that a new post would be appropriate. Cell range D5:Q30 is the range that the user sees & uses to enter leave. Cell range AI5:AV30 is what the system uses to conditionally format Cell range D5:Q30 when an individual...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top