Forum
Office Software
-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
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/Closed]
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...
-
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
-
Excel calculator issue [Closed]
Hello, I am trying to create an excel calculator to calculate the holidays a certain employee has accrued depending on a set of conditions. I...
-
VBA command button [Solved]
Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and...
-
VBA - Button saves TextBox data in dif. Workbook
Hi Everyone, I need some help creating a code that will allow me to save data input into a TextBox to a different Workbook called...
-
Count total quantity by date into month [Solved]
Hello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order...
-
How to use conditional formatting 30 day notice
I have an excel document that I have set up some conditional formatting and use of icon sets. The only issue I am having, is programming the 30...
-
Not implemented error message in Outlook 2013
Hello, When I try to send an Email to my client suddenly an error message display: “Not Implemented Error Message in Outlook 2013”. There is...
-
Lookup or match [Closed]
Hi, I have a column in which I have a value I need to look up, then in same column anther value I need to find then return value in column that...
-
Copying specific cells
Hello, I am trying to use a command button to copy information from specific cells in sheet 1 to a excel form I made in sheet 2. The cells are...
-
Saving multiple Excel files based on a list [Solved]
Hi, I'm totally new to writing macros in excel but I thought I'd give it a go. I've seen similar threads but I can't find the answer to my...
-
Count Qty by mth to the order date [Closed]
Hello, I need a formula that helps me calculate the quantity by month to the order date and also by venue and type. I have tried to use a...
-
VBA code to copy and paste data multiple times
Hello, is it possible to parse a column and find a value in it, and copy and paste a particular range based on that value in the previous...
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD