help me please

I am trying to work out how to work out how to change one of two cells depending on if either of them has a value in it. Its to work out either the amount of discount wanted or the % of discount wanted. Because of this i cant put a formula in either field so i made a discount field for in...

:confused:Good Morning, I'm creating a log which has the following columns: Date Issue Found | Date Query Raised | Date Query Resolved | Reference | Notes What I want to happen is for the log to show me which is the oldest Raised Query (column B) but excluding any that have been resolved...

Hey there, Excel Gurus! I've just come by an old toughbook touchscreen tablet, and I want to create a spreadsheet with buttons to make data collection easier. Nothing too fancy, just left click on this button results in a +1 result in a tabulating cell. It would be nice to make multiple buttons...

Hi, I have a pivot table that uses the OFFSET function to drag in my data dynamically as kindly shown by Bill "Mr Excel" Jelen. The issue that i am having now is that im having now is that when i go to filter my data i get a alue of "0" that can be filtered on. If i look in my data, there is...

hi, I have this spread sheet Download file example.xlsx . What I trying to is segregate each record from Personal Details into each sheet. For example Laura(a2) had Make up(b2), so she needs to land in Make Up sheet, or Kate(a3) had manicure(b3) and has to be in Manicure sheet. Does anyone know...

Hi Everyone. I'm new here but really need some help (I'm rather new to this all); I'm completely stuck and have been searching everywhere for a solution for a while now. I essentially need to create a table with the references (without duplicates) with their corresponding maximums. I...

Hi guys, Ive been struggling with this... I have a table with a range of values (AE6:AE15) for which I want to show data bars inside the cells. I want the data bar configuration to be the shortest bar to correspond to the largest value and viceversa. However, this column has both negative and...

Hello everybody! :) I have been attempting to cobble together code from different forums for the past several hours to make a macro to unhide a specific number of worksheets based on a cell value, and have failed miserably thus far. To that end, I thought I would try appealing to you nice folks...

I am using MS Excel 2010. I have created a custom list with the following data in this order: CY2010Q1 CY2010Q2 CY2010Q3 CY2010Q4 CY2011Q1 CY2011Q2 CY2011Q3 CY2011Q4 CY2012Q1 CY2012Q2 CY2012Q3 CY2012Q4 CY2013Q1 CY2013Q2 CY2013Q3 CY2013Q4 I have selected the entire worksheet by clicking the...

So I admit, this is probably way easier than I've made it out to be, but considering I've spent most of two days trying to figure this out and have yet to do so, I have arrived here, desperately hoping someone here will take pity on me and help me out. I have two sheets in a file called...

Hi there again! I would like to ask if there is any way that I can make a conditional formatting formula changing my color font from being transparent. I made the font color of cells A1:A10 transparent by customizing the format with ;;;. But, if B2 has value, how can I bring back the font color...

Hi everyone, thanks for looking. i have the above raw data.......i'm trying to get to the output shown below using VBA. There is about 1600 rows of data in my raw data set and they need to be consolidated into the output table shown below. there needs to be four of these output tables, one...

Hello Guys, I am a new guy :confused: here and I would like to ask to all sifus and experienced people, how can I remove character for example: -61BRE6195L to become BRE6195L -132339359L to become 339359L -2AN25-21 to become AN25-21 Your kind help is much appreciated. Thanks in advance.

Hi All, I have an excel document with three sheets in. The sheets that require attention are "Sheet 2" and "Sheet 3". Basically "Sheet 2" is pulling data from "Sheet 3". "Sheet 2" is laid out differently to "Sheet 3" as it is the sheet that is used for printing the data. So I have set up a...

Hi, I'm really hoping someone can help me please. I've extracted approx 9000 rows of data from a paper document using some OCR software, which I now need to get into a format that I can put into a database i.e. account, address line 1, address line 2, address line 3 etc. As you can see in the...

Dear Potential Helper, I am in the process of creating a database, and have used 'Data Validation' to create drop down lists in order to obtain information quickly from the database. I have encountered an issue where if I have a list the resembles the one shown below, the drop down list will...

Help!!! I'm having tons of trouble when it comes to this piece of excel heaven and cannot figure this out. My excel spreadsheet currently has a cell labeled [Days_Since_Received] and excel is figuring time in the system in Calendar Days. I need it to calculate into Work Days (M-F) or Business...

I have attached the google docs for my excel spreadsheet and the list of steps i need to complete, at this point I need help with the first 3 sentances in # 5 and all of #7 https://docs.google.com/document/d/168EFIMexqkv9w4nmMgmzxhjCeSYShuRbcm-QHKUaa-c/edit that is the list of steps and here...

Someone please help me with these formulas! I am so upset I can not figure these out. PLEASE HELP :( 1. Enter a formula to calculate the number of gallons billed, based on the following rules: If a customer's bill is waived (Bill Waived column) or the number of gallons used is less than 25,000...

the code is to create chart and but name, title, range, style and type for chart the code run well except type and style any idea Charts.Add With ActiveChart .HasTitle = True .ChartTitle.Text = Application.InputBox("Please enter chart Title", "Chart Title", "As of " &...