normal

When it comes to rounding I use excel like everyone else. I’ve recently come across an engineering specification that rounds up or down to an even decimal place if the second decimal ends in a 5. i.e 2.45 to 2.4, 2.75 to 2.8 and normal rounding occurs otherwise 2.44 to 2.4, 2.74 to 2.7 and 2.53...

My personal computer has a weird quirk where the area of a cell border that I can interact with to drag-and-drop or autofill is smaller than on every other computer I have used excel on. On other systems, when I click on a cell, I can easily click the border and drag the cell contents to...

Hello I'm in the process of creating my first database. I've quickly learned that look up tables aren't the great thing they first appeared. So I've tried to switch the look up tables to a normal table by reclassifying them in Design Mode as 'Text'. But when I look at the relationships the...

Hi all, Because I need to print on other printer than default, I use VBA code to show all available printers, then select needed printer & print: Sub Show_PrintersDialog_and_Print_Cards() Application.Dialogs(xlDialogPrinterSetup).Show Call Print_Cards End Sub The problem is this...

Hi All, Thank you for viewing my post. I am having difficulty with the index/match function. Below is an extract of my table (I had issues uploading the table via the normal channels). <table border="1" cellspacing="0" cellpadding="0" verdana,="" arial,="" tahoma,="" calibri,="" geneva,=""...

Hi all, kindly require a VBA code by which should run thought col. “D” & “E” and if both col. are blank should clear any data or formulas from col. “Q”, “R”, “S” and “T”. Below I present the original data and the expected result Thanking you in advance Original data <tbody>...

Hello All, Is there a way to export a pdf, or import a pdf to a csv file, or normal excel file? Thanks for the help

Using Excel 2016, my file is set to open with 2 views. How do I change it to open in only 1 view (the normal way)?

On my pivot table most of the numbers are "normal" but some display in scientific notation (-1.4210854715202E-14). When I change the format in Field Settings to number they look normal. However, when I copy and paste the data to another sheet (as values) it displays in scientific notation...

My old business partner thought comment boxes were a great idea. He is gone and I have these boxes that pop up when you are in a cell. However, they are not normal Excel comment boxes. I don't know what they are called, I can't edit or delete them. I'd prefer to get rid of them all together...

I've seen various q+a around this topic but can't get any of the suggested answers to work. I need help crafting a formula to find the number of unique companies that are both Special per column B and have an Investment Date in column C. I'm able to calculate the total of 5 Special companies...

Hi I am working on a sub which has a userform as part of the macro, there are some calculations based on the information the user puts in the user form, some of the calculations are on time so the user needs to put a : between the hours and minutes and seconds (12:45:29) some are based on...

Hi, I tried to post a new thread about 3 hours ago and nothing has come through. Just wondering if this is normal procedure and if a mod could please look into it Thanks

Hello, I am reporting on events that can occur at any point and for any given duration. I am given a timestamp for the start of the event, and a timestamp for the end of the event, so can work out the duration easy enough. I need to, however, determine how many hours of this event occurred...

I am using Excel 2016 PowerPivot Pivot table and in page field some items are filtered. Then I double click some numbers in the table and this warning prompt comes up "Show Details cannot be executed when multiple items are selected in a ..." Hey but there is no such irritating error when I...

Hi, I've put together a test table and formula - see below - which works but I need to make it more flexible with wildcards.. please can someone tell me how? Table pasted in Cell A1: <colgroup><col><col span="2"><col><col></colgroup><tbody> Order Type BOM Item Sales Value DISPLAY VOLTA...

Hi all. I have a fairly complicated question and I've been racking my brain for a while. I have the following data set: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 146px"><col width="79"><col width="83"><col...

I have a problem about my wbc counting. A1 3000 b2 5000 c1 2500 d1 show Lower if less than a1 Greater if higher than b2 and normal for between 3000-5000 by using number to check standard between a1-b2. Thanks you.

Hi all. I am new to this forum. I have a worksheet where a person has to work 208 normal hours for a basic salary. If he work less than 208 but has any sunday or public holiday time then i want to take the difference of normal hours less 208. Then from there i need to pay the sunday hours at...

I have issues with this formula that is very hard to write. The formula is: If G111 is YES and F21= normal loan use one formula otherwise 0. If G111 is YES and F21= interest only loan use another formula otherwise 0. That is my formula like now. (my excel is in Italian)...