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,...
-
Convert number to spelling [Solved/Closed]
Hello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) =...
-
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...
-
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...
- More »
-
Microsoft download [Closed]
Hello, I need a link to download Microsoft office 2010. exe
-
Auto fill dates [Closed]
I am trying to figure out that if i make a change (like fill in a amount) in colum A1 (for example) that in colum E1 today's date will automatic...
-
Find and replace in Excel
Hi, This question is related to Excel 365. I have Sheet1 that has two columns. I Just gave a sample of word abbreviations. It has around...
-
Conditional Formatting Columns
Hello, I would like to know if there is a way to conditionally format a column. I want cells in column C to highlight if they are higher than...
-
Customising slides identity (Software)
Hello, The company I work for is going through a merger and all of our presentation are going to be merged. I am aware of the edit master...
-
If function with printing tool
I have 3 column " Nu, Item, QTY" I want to print the cell who has a qty with the same Nu sort. nu item ...
-
Explanation of formula used on conditional formatting [Solved]
Hi, Could someone please be able to fully explain how the following formula works with regards to conditional...
-
Server Connection Error [Closed]
I am getting connection error whenever I am trying to copy a 2 gb file from the server. What wrong I am doing or is there any setting problem...
-
Populate separate worksheets with data from main worksheet based on criteria met [Solved]
Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that...
-
Incorrect date while saving csv format
Hello, I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and...
-
Picking data from a table
Hello, I am going to apologise once again in advance as I am terrible at coming up with the right question when it comes to excel formulas hence...
-
Explain conditional formatting formula [Closed]
Hello, Is someone able to fully explain how the formula =AND(start_of_range"", NOT(ISERROR(MATCH(start_of_range,list_name,0)))) works...
-
Excel IF formula - Priority setting
Good day I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option...
-
VBA comparing two files via rows and copy difference to third file
Hello everyone! I'm new to VBA and need your help! I need two compare two files (File 1 and File 2). I need to compare rows in File 2 to rows in...
-
HELP with IF function [Closed]
Hello, So I have a problem with my file. I need to use IF function, but I don't understand. The main thing is that I need to calculate the days...
-
Excel [Closed]
I am trying to change date format to dd-mm-yyyy, but the format remains unchanged
-
Conditional formatting [Closed]
I want to make a formula in excel that if a cell in one column is not filled in within 7 days from the day in a cell in another column but in the...
-
Copy-paste some grid in excel
Hi All I know this topic is quite old by now but. Haven't found the solution yet. I tried to copy-paste some grid in excell when i noticed. It...
-
Paste value on filtered cells [Solved]
Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several...
-
Regarding all fields by selecting individual ID
Hello, I have a JSON file it contains 100 IDs and all their details, but when I type ID I need to get entire details of that person from JSON...
-
Office Enterprise 2007 setup cannot find Word.en-us\WordLR.cab
Hello, here's is my problem. On setup, it says that setup cannot find Word.en-us\WordLR.cab. Please help. System Configuration: Windows /...
-
Formula I should use [Solved/Closed]
I am so confused on what formula should i be using for my work...? Which should be ending up like this...
-
Excel Cell Color change from another cell date fill up.
For Example, 1 item due date is 10/Nov/18 & showing yellow color. when the next cell will in-house 9/Nov 18 than the previous date color will...
-
Compare Excel sheets using Python
Hello, Can you please solve this question.To compare two excel sheets and copy unlike data to a third sheet which is not deduplicated.Can you...
-
A combination of SUMPRODCUT/ISNUMBER with LOOKUP
Hello all, hoping someone can help CELL (A) I have a question where, I have a column of data where there is a missmatch of data. CELL...
-
Background formatting from two values drawn from formulas
Hi. I've created a table displaying prices from suppliers. On the end two columns I've added a formula to show the header of the colomn which...
-
Duplicate line and decrease Id number
Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that...
-
Help me find the percentage in amount [Closed]
Hello, How much is 65% for 25000 crores System Configuration: Android / Chrome 70.0.3538.80
-
Conditional Formatting using dates/data in an adjacent cell
Hello, I am creating a project status sheet where dates entered in an empty column (Column C) that are past the "planned start date" (column B,...
-
Copy and paste one cell into 48 and then repeat
Hello, I've tried to piece together how to do this function and I feel like it's simple but I need help please! Here's the recording for 2...
-
Python code [Closed]
Hello, The script above to compare two excel sheets and copy like data to a third sheet works great. What would be the opposite formula? Two...
-
Convert numbers to words
Hello, I want to covert a number 276120 as Two Lacs Seventy Six Thousand One Hundred Twenty but Using above code i can convert the number as Two...
-
change excel format
Hello, how do i change the excel format of 02.07.2018 in to 02-july-2018 there is no option in Custom format because the separation is in...
-
Watermarks and Section Breaks
Hello, I am trying to create a digital letterhead that has the ability to have multiple pages, but the watermark only on page 1. When...
-
Inserting pictures from folder using macro
Hello, I would appreciate if someone would help me. I never used macro until today and I searched for a solution but I just don't...
-
Macro to check value in various cells [Closed]
In column B. I need to check cells in random order. If there is value then display msg box. For eg If cell B3 value = ABS then msg box...
-
Comparing two columns using partial match logic [Solved/Closed]
I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA....
-
Automaticly change currency format in cell
Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually...
-
Copy & paste issue
word properly copying, however pasting while word into incomplete being. (not entire text). just some letters receiving. some places no, word...
-
How can I restore images that saved on Word File? [Closed]
Hello! Is there any way via which I can restore some images that I have saved on Word 2013? I have already used some manual methods Like Open...
-
Trying to create a ticket log spreadsheet [Closed]
Hello, I am trying to create a ticket logging system for my team at work and have created a sheet with 4columns each with drop down lists for...
-
Generate simplified data from RAW data
Hello guys, i need help to create some magic from excel. I am a marketer for a F&B, and right now i am in the mid of trying to generate some...
-
Price of MS Office Word
Hello, What is the price of the microsoft word 2013 after the initial 1-month trial?
-
Copy rows to rows on another worksheet if " ✔ " [Solved]
Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago...
-
unlocked [Closed]
Hello type:RM-436 ic: 661U-RM436 Model Nokia 7210c /FCC id: ppirm-436 made in Hungary 359310/2/459243/8
-
Auto populate weekday from a separate date entry
Hello, I am wanting to do two things: 1. In the first column I want to add in the date, in the second column I want it to automatically...
-
Pass fail result including absent is fail [Closed]
One student passed in 5 papers out of 6 papers but 1 paper absent in this exam.actually this student is fail.How to calculate the result in excel
-
If, Time, Text, Blank Cell [Closed]
Hi, I have multi shifts as under; 6 to 14 = 8 7 to 14 = 7 14 to 22 =8 22 to 06 = 8 22 to 7 = 9 I am using =IF(E3>=D3,E3-D3,24...
-
Unable to open a file
Hi everyone, I cannot open only just this one file. I keep getting a message that 'Visio cannot open the file or a component in the file...
-
Create a macro for a data set [Closed]
m trying to create a macro for below data, the series of data will be in below format. Bahrain United Arab Emirates Oman Qatar