Forum
Office software
- Popular discussions
-
if cell = date return yes or no. [Solved/Closed]
Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes,...
-
if date in cell is greater than date in cell [Solved/Closed]
Hello, I am a beginner with formulas in Excel. I am working with dates formatted dd/mm/yyyy. I need a formula that will return a value of yes...
-
to calculate positions(1st,2nd,3rd...so on) [Closed]
Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my...
-
Removing " false" value in "IF&quo [Solved/Closed]
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an...
-
percentage calculation [Closed]
Hello, how to know the percentage example total bill amont is Rs. 25000 and we r paying Rs.18000 can u please help me how to get the percentage
- More »
-
Change date format in Excel
hi there i just need to make 1 cell for a date but with auto population of slashes so if i type 21062018 in the cell it comes up like...
-
Date Formula counting days
Hello, If anyone could help me, I would greatly appreciate it, I need help with counting days if there is not an end date on the report. Ex:...
-
Comparing two columns in Excel
Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...
-
Overwriting data during transfer
Sir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command...
-
Autopopulate info from Master to individual WS
Hello, I have a series of data that are categorized by a prefix (P, UR, A, CAPA, etc.). I want to pull only the CAPA record information into a...
-
counting days on a report [Closed]
I need help with counting days if there is not an end date on the report. Ex: Count the days from the admission date to the end of the month I...
-
Create sheets for additions to list on sheet one.
I have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. ...
-
How to get the first worksheet only? [Closed]
Hi I'm new in VBA. My program should let the user choose a folder of excel files. Then it will automatically copy all of the first worksheet to...
-
Populate cells in worksheets from an updating list
I have a club workbook with 150 member Worksheets that need to be populated from the members list. First Member is starting with A2 Second A3...
-
VBA code for command button [Solved]
hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to...
-
Auto scroll in phone
how to auto-scroll pdf files in android phone? please suggest the method or the relevant software.
-
Multiple text in a cell
Hi Please can someone help I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to...
-
Multiple columns into a single column [Closed]
Hello, I am using excel 2013 and I want to convert a range of data with variable no. of columns and 24 rows to a single column (columns...
-
Vlookup where table arrary contains certain value [Closed]
Hello, I have a "Key" Code Value 000 Black 123 White and another sheet with the data below Data ...
-
Compiling data in excel
Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest...
-
looking for VBA code. [Closed]
HELLO EVERYONE, I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO...
-
MS office 2010 for Mac
Hello, I need to download office2010 for Mac.Can you please help to get download linx System Configuration: Windows / Chrome...
-
Need product key of MS Office 2010
Hello, Kindly help me to avail the product key to use MS office 2010 System Configuration: Windows / Chrome 67.0.3396.87 Regards,
-
Access to Word mail merge
Hi there, I am using MS Office 2016, I did a data base in Access for my team, such as Employee ID, Name, Mobile, ... and signature. when I...
-
Auto update of data from one sheet to other
Hello, Pls guide me regarding how to update data from one sheet to other in excel. In sheet1, if i update the details of the student it...
-
Creating Excel Email Alert For Expiring Dates
Hello, all I want to do is to create a code that will send me an e-mail when one of my docs will be expiring or expired. The problem is that...
-
Using PDF to change documents to JEPG [Closed]
Can I use PDF to convert documents to JEPG format?
-
How to combine/merge multiple rows into single row [Closed]
I have name of person in 1 row and multiple car names owned by him in different rows .How to combine these rows together so that name is in one...
-
Copying and looping data from one file to another
In one tab I have information, where I have made it output the information on a second tab (It's more in depth than this but I tried making this...
-
Not able to activate Mobile PDF or Albite Reader
I want to have a PDF reader for my Java-enabled mobile phone (Samsung Metro B313E ). I have downloaded Mobile PDF and Albite Reader, both of...
-
Convert date to the English spelling
Hello, My date of birth 1-3-1995 Please convert to the English spelling System Configuration: Android / SamsungBrowser 2.0
-
Can I recover anything from a 0KB PST file?
It's urgent. The Outlook data file which was absolutely fine yesterday has now turned into a 0KB file. This morning when I tried to open it, I...
-
VBA - how to repeat a set number of values X times
Hi, I am having an issue with a code I am writing. I want to insert 1,2,3,4 down an empty column X times ( where X will be inserted by the...
-
Mac VBA & Excel, auto change image based on a cell
Hello, I'm trying to produce a simple excel spreadsheet on my Macbook which automatically changes the image in cell B3 when I change the name...
-
Auto populate when changing from quoted to sold?
Hello, I am working on a work book in excel for work. On one page, I am tracking quoted / sold cases when a case sell, I have it change...
-
Microsoft office product key [Closed]
please send me product key
-
How do i install excel on my pc
how do i install excell on my pc
-
How can I separate each slides from one PPT file? [Solved]
Hi Everyone. I have a powerpoint file(Power point 2016) which has 100 page(slides). What I want is to automatically separate each slide to...
-
Birthday [Closed]
Hello, 17/03/1996 in word
-
Microsoft 2010 product key [Closed]
I downloaded free version of Microsoft office 2010 from your site its asking for a product key. Where do I get that from? Knemet
-
Scale Tab in Format Axis in Excel 2000 Charts
Hello, Using Excel 2000 charts, in some files, when I right-click on the horizontal (Date) axis, select the Scale tab in Format Axis, I get a...
-
Deleted Outlook profile
i have deleted my outlook profile in control panal . nw im not getting the outlook file . how to retrive or view that file
-
Macro which copies formula down to end of row
I am new to this this and would be grateful for any assistance with a macro which copies the formula from the cell above and continues in a loop...
-
When the field is =N, want to subtract that field [Solved]
Hello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that...
-
Excel autofilter stops filtering [Solved/Closed]
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I...
-
security code
Hello, what's the security code? System Configuration: Windows / Chrome 59.0.3071.115
-
How to recover deleted word file
Hi Please recover the deleted file from my system. i tried many ways but not able to get it properly. is it possible to get all word] file ?
-
Conditional formatting across multiple columns [Solved]
Hi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two...
-
MS Excel file error message
Hello Folks, There is something wrong with my Excel file. It was working fine on last night. Today, I opened it anf got the following...
-
Using word
Do I go on line before I can use word, and can I print anything after I use word?
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is...
-
Conditional formatting across columns [Closed]
I have two columns which if equal(unless blank) I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) and specify...
-
Data transfer from master to other sheets by type
Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin...
-
Highlight blank cells if data present within row
Hello, So I know it's using conditional formatting but I can't find a formula for what I want. I only want the blank cells highlighted, not...
-
Master sheet populating data to other sheets [Closed]
Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin...