HOw do I do this
if in col a is number 1 show the same row col b as is
if in col a is number 2 show the same row col b as bold
Thank you
Dagmar
| |

Firstly I have a selection of columns that I am counting how many times a particular value appears.
Then I have a second criteria that if a result is found within the first query above, then check a single column for a second criteria.
The issue I am hav ...
Read More
| |

plz help me y when i put sum formula the result is zero,,,knowing that the formula is right ,,
| |

Hi Folks, I'd appreciate any help and many thanks in advance for taking the time.
I've excel 2007 and I'm trying to built a table .
column A will contain a number of random figures from -1 to 100.
The table starting in column C through to column AB w ...
Read More
| |

Hello Everyone!
I am using the following formula:
{=IFERROR(INDEX($D:$D,MATCH(1,SEARCH("*"&$D:$D&"*",A1),0)),"")}
I need it to search the entirety of column D, but if there is a blank cell it stops. I don't want to place specifics such as D1:D34 bec ...
Read More
| |

Ok so I need to create a formula that does a couple of things I am not even sure if it is possible. I need to find a specific value in three different columns which I can do but I also need to pull dollar values from other columns that correspond with the ...
Read More
| |

I'm trying to write an IF formula that would return T or F if a file exists in a network folder. Can someone help? Thanks
| |

I'm stuck on this formula:
=IF((AND($E19<=$C19, $H19>1)"Good Job"),IF($E19>$C19,"Too Much Time","Poor Quality"))
I've tried entering it a million different ways and the best I can get is a #VALUE error. Could someone help me correct it and also unders ...
Read More
| |

In calculator Tan(74.7) = 3.6553843546 But in Excel 2016 Formula =Tan(74.7) = -0.839256394 In calculator cos(94.06863367) = 0.0709513889 in excel 2016 cos(94.06863367)=0.983996237385602 So Please Help Me
Read More
| |

I've been given a preexisting template to work with, and I'm struggling to reconcile it with the graph I've been tasked to create. I'm attempting to combine each pair of highlighted cells on the "Printable" sheet to populate the corresponding cells in "D ...
Read More
| |

I have a sheet with values and a second sheet that uses the values from the first one. When I change the formula in one cell, the other cells from the same column get changed too even there is no formula connecting this two cells together. Also, it happen ...
Read More
| |

Hi, how do i write an Excel formula that would output the total number of contacts Lucy had on Februray 14. thanks!!
A B C
Date |
Login |
Contacts |
12-Feb |
kate |
110 |
12-Feb |
Lucy |
110 |
13-Feb |
Kate |
120 |
13-Feb |
Lucy |
140 |
14-Feb |
Kate | ...
Read More
| |

**EDIT:** **PROBLEM SOLVED** (SIMPLE FORMATTING ERROR --> **Solution** is to change column E format to **Number** if set to **Date** format)
Hello,
I am trying to make a countdown timer for various ToDo Lists I make and was thinking the following formula would work:
...
Read More
| |

I have a total sold column in each of the 10 tables i have in my workbook (each on a different tab). Not all tables contain the same items but most do. For example "Coke" may be on 5 of the 7 tables. I want to pull the total amount of Coke sold across all ...
Read More
| |

I am trying to join two datasets (csv format) by using conditional if statements. First dataset is accident information which does have a unique id (caseno) and the second dataset is roadway information which does not have a unique id. To join the acciden ...
Read More
| |

Hi all,
I don't know how to solve the following issue. I want to automatically calculate colmn I.
I need to built the followin logic: when a cell exceeds a certain amount (column B), the difference has to be transferred to next month unless the limit of ...
Read More
| |

I am looking for help with a formula .
I have an IF logical test set up for a cell on Sheet 1 that if it says "YES" then what I want it to do is take 3 cells from Sheet 3 A1:A3 and copy them at sheet 2 in a cell( or multiple cells)
At the moment I can onl ...
Read More
| |

**Task**: cataloging receipts from expenditures.
Have receipts with multiple items listed. The subtotal has been discounted from the original retail price by 10%. That discounted subtotal is then marked up by 7% (tax).
Would like to make __only one numeric entr__ ...
Read More
| |

Good afternoon all,
Looking for assistance with building a formula. In short, i want it to search for any gaps between Column "B" and column "C". Additionally i would like to build a rule so identify "Starting before a specific time" and past a specific ...
Read More
| |

I am working on an excel spread sheet and unlocked specific cells to allow users to enter daily information and pictures. A macro was created to spell check and now when the users enters the information and pictures and runs the macro it locks the picture ...
Read More
| |

When entering IF function I receive the following feedback: "Are you trying to enter a formula?" Please see attachment.
Need urgent help as I have lots of data to process.
| |

Good day. For an example I would to roundup figure above decimal .75 but in between if the figure below decimal .75, I would like to rounddown. May I know what equation I should use in order to have this effect.
Thank you
best Regard
Mr Khoo
Read More
| |

I have a workbook (not created by me) that has all expenses per month on 1 sheet. There are 12 sheets in total. On the 13th sheet I would like to be able to input a name of a Vendor, which can either be in column C or E. If it finds it anywhere on the 12 ...
Read More
| |

I've created a 'monthly sales' workbook, listing individual line items from orders. Data comes straight from a Magento 'order export' function.
I'm taking each line item and summing onto a separate sheet to give a daily total (and breakdown). The source ...
Read More
| |

Could use some help regarding a very basic IF function. All I'm doing is "if (A1) is less than (B1), show true or false"
A1 is the sum of 4 cells (C1, C2, C3,C4). C1, C2, and C3 are just numerical inputted values. C4 is an equals formula (add, subtract, ...
Read More
| |