The discussions
Comparing 2 excel reports
Hello, I need to match a payroll report to a vendor bill. The payroll report includes name, deduction amount their relevant information and t...
How to convert amount into words in open office excle
Hello, I am using open office excle I want convert amount into word format Plz give me explecation with exp, Configuration: Windows 2...
Combining multiple word documents into one
Hello, I have a short and should be simple task, but I want to be certain. I am an idiot and I wrote all the pages in my catalog on (in) seperate...
Conditional formatting: color of a cell by date and value
Hello, I am attempting to have a cell change colors based on the amount of time passed since a bill was sent, only if the bill is unpaid. In colum...
Compatibility
Solved/ClosedHello, I was just wondering if the free download for Open Office is compatible with Windows 8.1, as I did not see it listed. Thank you and have a gre...
Fill data according to other sheet's data
SolvedI have a sheet1 like this: r1 text1 text 1 r2 text1 textx 2 r2 text1 textx 0 r3 text2 texty 1 r4 text2 textz 1 r5 text2 textx 3 r6 text2 text...
,">"&0),"") at the end of a countif formula
Hello, I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls? =IF(COUNTIF($AJ$2:$AJ9,$AJ...
Conditional formatting in excel 2010
Hi, I'm wondering if there is a way to tell Excel use conditional formatting on a cell when/if another cell has conditional formatting to it. Basical...
About dated if function
Hey again, i had to use this formula to find the deference between two dates =DATEDIF(E4,F4,"d")+(1) it shows me (1) in all the empty cells...
Compare values in multiple columns in excel
Hello, i have multiple columns with numerical values and I need to determine which one is the smallest value by row is there a function that can he...
Black screen with message
My computer says disk boot failure, insert system disk and press enter. My computer is 8 years old and I do not have a disk for the vista windows pack...
Black screen with massege, disc boot failure insert
Hello, My computer says disk boot failure, insert system disk and press enter. What should I do? Thank you, Charlotte Configuration: Windows ...
Excel macro to list current costs by code and extract previous
Hello, I am looking for a macro, that will list one set of values by a code and then move a precious list of codes with values and subtract one from t...
Lan computers sending messages to each other without internet
Hello, Could you please help me with a problem. I have computers running windows 7 and networked and am trying to get a way to train users to use ...
Macro gives me expected en sub error
Hello, I have the below macro, but it gives me compile error expected end sub. This macro below I have copied and paste hoping it would work becau...
Conditional formatting excel drop down list
Hello, I want to color code a drop down list in excel? I have done conditional fomatting on each cell in the list, it is a text list, but not wor...
Type name into a cell removing name from another unique list
Is there a way to manually type a name into a cell on one worksheet, that removes that name/entry from another large list, with unique names, whether ...
Merge the selected sheets data into one data
I am having 5 sheets (Name as Ricky, Rambo, Input, Output, Time) data combined into combined sheet , for this i need to run through macro Please hel...
Comparing values in multiple columns
Hi All, Would appreciate if you people can help me, as am not that excel expert :( My argument is like this- Column: 1. 2. 3...
Powerpoint advance course
i did powerpoint and i want to know if theres any advance courses for powepoint
Use of max and min functions.
hello there ,, I have two column names & numbers in different cells i need the highest number to display with the name next to it same with the...
Delete name from sheet1 as i type same name in cell of sheet2
I have a list of 10,000 unique people with corresponding statistics on a worksheet. These are also included on additional worksheets into smaller subc...
Automatically calculate random number as invoice number
Hello there! I am fairly new to macros and am trying to create an excel document that automatically insert a new randomly generated number (as the ...
To start the sumif from partial text on first row of the day
Hi, I have formula IF(COUNTIF(A$2:A1747,A1747)=1,SUMIF($A$2:$A$10000,$A1747,$G$2:$G10000),"")), which sums daily figures only for agencies by days....
Autofill destination
I created a macro to add a column and then to make the number in the column to the left of that column a negative number. I do that in the first cell...
Duplicate rows based on cell value
SolvedHi, Can somebody help me out with this. I want to duplicate rows based on input in a cell. can it be done in VB or macro or formula array? User wi...
Macro recorded to copy and paste only values
Hi, This is the first time I use this site and hopefully will get some help with this. Basically, I have a basic workbook which is populated everyd...
Chosen text in dropdown adds number in cell
Hello, I have a problem with my formula, If i choose a product "text" in a dropdown menu in cell C2, i want it to display a serial number in C...
Excel payroll work
SolvedHello, I'm using Excel to do payroll system. e.g. I create worksheet that showing data as below table :- basic more than 0.01 less tha...
Need help in date conversion
Please help me with a formula to convert ' 17/08/2013 02:06:02 PM' to ' 08/17/2013' in XLSX . Thank you.
Move data from one workbook to another
Hi I would like to move data from one workbook to another (copy & paste basically but there's tons of lines). The second workbook is in a differen...
Take out the ceros of specific cells, not the whole worksheet
how could I make the 0 ceros of an empty cell not to appear? I've tried going into customs and entering £#.##.00, which I got from somewhere though do...
Microsoft office word 2007 - displaying numbers across the pages
Hi all I have an issue which I have tried to find the answer to myself but have had no luck so wondering if anyone on here could help, the problem ...
Excel formular
SolvedHello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...
Excel equation
i want to formulate for eg:- inv date pymt terms amount payment due date jan feb mar apr 01.01.2014 30 1000 31.0...
Excel greater or less than
SolvedHi all, I'm having a problem that with multi counting with less than, eg. case 1: A1 = 1000 (total revenue) B1 = 3% (rebate) C1 = 2000 (free ...
Create worksheet based on lists & populate data from another...
SolvedHello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of it. I h...
Highlight cells based on a specific day of the month
Hi there. I have a bill spread sheet that is layed out pretty simple. I basically have all of my bills listed in the order they are due each month. Th...
Conditional formatting
Solvedhello I did a table in Excel ( its a vacation tracker) I'll give you an example for what i'm trying to do Ex : my vacation starts from 15-mar ...
Attendance sheet
Hi, I'm getting Confused and just need someone to help. I know I am looking for something simple but can't figure it out, i got some manhour she...
Search column b for matching value from a row in column a ....
SolvedSearch column B for matching value from a row in column A and populate D with the value that is in the matching row of B that was in column C, ie XYZ ...
Automatic transfer- with just one word
I just started a new job and my boss asked me to see if I could have the clients information automatically sent from the master page over to the overd...
Excel protect a column and a cell
Hello, how can i proctect excel column and cell Configuration: Windows 7 / Firefox 23.0
Compare column a to column b and return column c
SolvedHello, I have spreadsheet with names in Column A, phone numbers in Column B. Column C has the same names in different order. How can I ha...
Monthly spreadsheet for equipment hours- i'm stuck!
Daily log for equipment hours I want to make a file with 31 days of worksheets in the workbook for the complete month. The order of the workshee...
Convert datagrid data to raw data
Hello, i've a excel grid with data in rows and coluns with values in each pair (row/column). i need to transform each combination in raw data to p...
Possible to import pdf data onlin into excel?
Solved/ClosedHello, Does anyone know if it is possible to import pdf data from the internet into excel? Or do I need a special adobe acrobat program to do so? ...
Pdf to ppt converter
does anybody have pdf to ppt converter?
Copying data from one sheet to another conditionally
SolvedHi gang, I have a spreadsheet with columns A thru H being populated with text. I need to copy columns A thru H from spreadsheet 1 to spreadsheet 2 i...
Highlight row on one sheet if a number matches on another sheet
SolvedHello, I have a spreadsheet with multiple tabs. I am trying to figure out how to get a row to highlight on the tab called "Directory" if a number in ...
